On Sun, 18 Apr 2010 07:28:01 -0700, 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

Two different approaches:

=ROWS(M2:W200)*COLUMNS(M2:W200)-COUNTBLANK(M2:W200)


=SUMPRODUCT(--(LEN(M2:W200)0))


--ron