What type of data is in the range? Is it text, numeric, both?

--
Biff
Microsoft Excel MVP


"Eric" wrote in message
...
="", which is not defined as empty cell in excel, so counta function does
not
work for my case, do you have any more suggestions?
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