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...
One more variant
= ROWS(range)*COLUMNS(range) - COUNTBLANK(range)taking into account that COUNTBLANK counts both blank cells and cells with empty strings.