How in the world!????

[kfs]

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.

 

[Mike H]

Hi,

To count numbers & text in a range
=COUNTA(A1:C7)

to count numbers in a range
=COUNTA(A1:C7)

to count text in a range

=COUNTA(A1:C7)-COUNT(A1:C7)

Mike

to count text in a range

 

[Rick Rothstein]

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)

 

[Francis]

try COUNTA(A1:A30)
adjust the range to yours

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another

 

[Mike H]

that should of course have been

to count numbers in a range
=COUNT(A1:C7)

 

[Bernard Liengme]

So what's wrong with being a geek?

 

[Glenn]

So what's wrong with being a geek?

Or Greek, for that matter?