If, by the way, you are asking this question because you plan to average the
number (sum divided by number of values), you would want to use the AVERAGE
function for that; for example...

=AVERAGE(A1:A100)

--
Rick (MVP - Excel)


"kfs" wrote in message
...
Okay.. I have a table that has... say.. 30 cells.
22 of the cells have data in them.
How can I have a TOTAL cell that tells me how many cells have data in
them?

Please help.