How in the world!????

  • Thread starter Thread starter kfs
  • Start date Start date
K

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.
 
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
 
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)
 
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
 
Back
Top