Thursday, May 30, 2013

yogi_Fix The User Formula For Multiple Criteria Count To Ignore Counting Blank Cells

                                          Google Spreadsheet   Post  #1220
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 30, 2013
user rajvivek (http://productforums.google.com/forum/?zx=7m7yxfezh113#!category-topic/docs/spreadsheets/5k-NERoJugo)
How to let the formula ignore the blank cells?
The formula at this spreadsheet (in cell D3) is taking into consideration all cells including the blank cells, and giving result a part of which is undesirable (as shown in cell F10).

How could i edit the formula so that it simply ignores the blank cells and the out (in column F) should be for the actual data and not for the blank cells?

Thanks!
------------------------------------------------------------------------------------------------------------------------