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     www.energyefficientbuild.com.   May-20-2014
post by Samford: (https://productforums.google.com/forum/#!mydiscussions/docs/6k2s4kRVz4g)
Counting multiple criteria - formula works in old version of sheets but not the new!
Can anyone explain why this formula:

=sum(countif(C8:C12,{"DCP","CO2","WC","F","FM"}))

... 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..
--------------------------------------------------------------------------------------------------------------------------------------------------------