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,

Reference at https://docs.google.com/spreadsheet/ccc?key=0AjJXY6WtI3JmdHRNVUhmZU9EdDRmM0stUHVhUkNlUnc#gid=0

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