Monday, April 29, 2013

yogi_MultiCondition Count Of Unique Entities In Column A Provided There Is No Corresponding Nil In Column B


                                          Google Spreadsheet   Post  #1162
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 29, 2013
user Lewis TW Koh (https://productforums.google.com/forum/#!mydiscussions/docs/STG-8g-mJjw)

Hi Yogi,


I have shortened the list to make it more clear.

There are 9 fruits (Apple 1,2,3, Pear 1,2,3, and Orange1,2,3)
Orange 1 and Pear 2 is marked "Nil" in column B.
Pear 3 is repeated in Cell A11 (should not be counted)

The total number of fruits in cell C16 should be 7 instead of 8. It is currently showing 8 because the formula counted Pear 3 in cell A11.
----------------------------------------------------------------------------------------------------------------------------
following is a solution to the problem