How to count the number of cells not empty?
it counts the empty cell too,
Do you have any suggestions on how to fix it?
Thanks in advance for any suggestions
Eric
"Sheeloo" wrote:
Try the formula
=COUNTA(M2:W200)
in any cell outside the table.
"Eric" wrote:
I get a table from cell M2 to W200, and would like to count the number of
cells not empty? which the cell equals to "". Does anyone have any
suggestions?
Thanks in advance for any suggestions
Eric
|