tag:blogger.com,1999:blog-4355584967795500738.post5315513581989787791..comments2024-01-20T18:09:39.637+08:00Comments on My take on Technology: Google Spreadsheet tip: how to SUMIFSAnojhttp://www.blogger.com/profile/02266923349466748615noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-4355584967795500738.post-84914346749941738042013-06-02T11:53:37.990+08:002013-06-02T11:53:37.990+08:00@moimart, it works the same way.
For instance in ...@moimart, it works the same way. <br />For instance in my example if I want to count rows in 2011 with more than 100k earned, you can use >1000 directly since D contains numerical values<br /><br />'=count(filter(D2:D11,D2:D11>1000,A2:A11=2011))Anojhttps://www.blogger.com/profile/02266923349466748615noreply@blogger.comtag:blogger.com,1999:blog-4355584967795500738.post-15060000422636200772013-05-31T03:19:29.899+08:002013-05-31T03:19:29.899+08:00How would you input a ">0" criteria? ...How would you input a ">0" criteria? if i leave it with the commas it would read it as a text, right? if i use A2:A11=>0 it's an error too<br /><br />Great tip, thanks!moimartnoreply@blogger.comtag:blogger.com,1999:blog-4355584967795500738.post-91341023094694777722013-05-28T18:38:41.723+08:002013-05-28T18:38:41.723+08:00Good... This helped me. Thanks
Good... This helped me. Thanks<br />Amitnoreply@blogger.comtag:blogger.com,1999:blog-4355584967795500738.post-9808312506423660692013-05-24T11:17:18.281+08:002013-05-24T11:17:18.281+08:00Perfect..This is what exactly I was looking for. H...Perfect..This is what exactly I was looking for. Helped precisely.Akil Narayananoreply@blogger.comtag:blogger.com,1999:blog-4355584967795500738.post-71264496328755631042013-05-09T10:07:50.862+08:002013-05-09T10:07:50.862+08:00Thank you so much for this article. Been looking e...Thank you so much for this article. Been looking everywhere for this !Sainte-Anne Justice GMhttps://www.blogger.com/profile/12076672795919899105noreply@blogger.comtag:blogger.com,1999:blog-4355584967795500738.post-4439509676686354612013-04-17T02:08:37.969+08:002013-04-17T02:08:37.969+08:00Super Helpful! Thanks!Super Helpful! Thanks!Dustinhttp://www.ropesouls.comnoreply@blogger.comtag:blogger.com,1999:blog-4355584967795500738.post-77907649906692969162013-04-12T20:52:30.862+08:002013-04-12T20:52:30.862+08:00 Graemac, it should work. If you can share your sp... Graemac, it should work. If you can share your spreadsheet I can take a quick look and let you know. Thanks!Anojhttps://www.blogger.com/profile/02266923349466748615noreply@blogger.comtag:blogger.com,1999:blog-4355584967795500738.post-34099394583452691012013-04-12T20:11:40.034+08:002013-04-12T20:11:40.034+08:00I am getting a circular depenency detected error. ...I am getting a circular depenency detected error. <br /><br />Any ideas?Graemachttps://www.blogger.com/profile/08369791091151393439noreply@blogger.comtag:blogger.com,1999:blog-4355584967795500738.post-35519459405956591122013-04-05T06:24:25.864+08:002013-04-05T06:24:25.864+08:00Nice, you can also make COUNTIFS and AVERAGEIFS u...Nice, you can also make COUNTIFS and AVERAGEIFS using this method. I wrote a tutorial myself on it, let me know what you think!<br /><br /><a href="http://spreadsheetpro.net/how-to-make-sumifs-countifs-averagifs-functions-in-google-spreadsheet/" rel="nofollow">COUNTIFS and AVERAGEIFS in Google Spreadsheets</a>SpreadsheetPro.nethttps://www.blogger.com/profile/04701900621225818734noreply@blogger.com