Forum Discussion
Countif Not Blank does not consider cell as blank if there is a formula
Issue: COUNTIFS formula won't count non blank cells if the non-blank cells are a result of a formula. Instead, COUNTIFS(range,"<>", etc.) counts all the cells with a formula in them, which means, all of them.
I use the formula: =IF(ISNUMBER(SEARCH("DM - ",C1)),C1,"") in the column where the non-blank cells need to be counted. The result can be either a text string or nothing ("") How to I count the number of cells with a textstring (and other criteria hence the countIFS)?
Thanks.
2 Replies
One more variant
= ROWS(range)*COLUMNS(range) - COUNTBLANK(range)taking into account that COUNTBLANK counts both blank cells and cells with empty strings.
In B1 (indicator only) and down:
=ISBLANK(A1)In E1:
=SUMPRODUCT(--(A1:A9<>""))In E2:
=SUMPRODUCT(--(A1:A9=""))
