Wednesday, May 21, 2014

yogi_ Count Number Of Items By Type From Multiple Items In Each Type

                                         Google Spreadsheet   Post  #1644
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May-20-2014
post by Samford: (!mydiscussions/docs/6k2s4kRVz4g)
Counting multiple criteria - formula works in old version of sheets but not the new!
Can anyone explain why this formula:


... works perfectly in the old version of Sheets and counts all the criteria listed, but when applied in the new Sheets - it doesn't work properly.

Here's how it looks in the new version of Sheets:

=sum(countif(C12:C25,{"DCP","CO2","WC","F","FM"})) This formula in the new Sheets only returns the number of items listed as "DCP" which is only the first criteria listed.
What has changed???
Any help is most appreciated!
Hi Yogi
thank you so very much for looking at this problem for me.  I tried your suggestion and it returned a value of "0" - which is not correct.

Here is a link to the spreadsheet, if that helps:

Thanking you in advance..