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...
In B1 (indicator only) and down:
=ISBLANK(A1)In E1:
=SUMPRODUCT(--(A1:A9<>""))In E2:
=SUMPRODUCT(--(A1:A9=""))