How in the world!????
 

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.

How in the world!????
 

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

"kfs" wrote:

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.

How in the world!????
 

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.

How in the world!????
 

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



"kfs" wrote:

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.

How in the world!????
 

that should of course have been

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

"Mike H" wrote:

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

"kfs" wrote:

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.

How in the world!????
 

So what's wrong with being a geek?

--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Francis" wrote in message
...
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



"kfs" wrote:

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.

How in the world!????
 

Bernard Liengme wrote:
So what's wrong with being a geek?


Or Greek, for that matter?