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

"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.
>

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" <(E-Mail Removed)> wrote in message
news:A4168648-1B97-4273-BDA1-(E-Mail Removed)...
> 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.
>

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.
>

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.
> >

So what's wrong with being a geek?

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

"Francis" <(E-Mail Removed)> wrote in message
news:C1A84537-13DE-4018-91C2-(E-Mail Removed)...
> 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.
>>

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

Or Greek, for that matter?