Title: How to use the COUNTIF function to count not blank cells
Headings: How to use the COUNTIF function to count not blank cells
How to use the COUNTIF function to count not blank cells
Download Excel file

Content: TRUE; TRUE; TRUE})*1)
becomes
SUMPRODUCT ( {1;1;0;1;1;1;0;1;1;1;1}) and returns 9 in cell B16. The formula above in cell C16 counts only non-empty values, it considers formulas that return nothing to be blank and space characters to also be blank. This is made possible by the TRIM function that removes leading and ending space characters. =SUMPRODUCT ( (TRIM (C3: C13)<>"")*1)
becomes
=SUMPRODUCT ( ( {"Green"; " Blue"; ""; " Red"; " Cyan"; ""; ""; "