How to create a formula that returns the number of non-empty cells in the Period range.
Answers
Answered by
0
order by
Up vote
14
Down vote
If you are looking for a number of cells containing numeric values, then COUNT() function is what you're looking for:
=COUNT(A1:D6)
If you are looking number of cells with non-blank values (numeric or otherwise), then COUNTA() is the right function:
=COUNTA(A1:D6)
The last formula works only if none of the cells have empty strings as values (i.e. none of the cells in the range have ="" or something equivalent in them). If that is the case, then this formula should be used instead:
=SUMPRODUCT((E7:G10<>"") * 1)
Up vote
14
Down vote
If you are looking for a number of cells containing numeric values, then COUNT() function is what you're looking for:
=COUNT(A1:D6)
If you are looking number of cells with non-blank values (numeric or otherwise), then COUNTA() is the right function:
=COUNTA(A1:D6)
The last formula works only if none of the cells have empty strings as values (i.e. none of the cells in the range have ="" or something equivalent in them). If that is the case, then this formula should be used instead:
=SUMPRODUCT((E7:G10<>"") * 1)
Similar questions