How in the world!????

kfs
Guest
Posts: n/a

 1st Apr 2009
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?

Mike H
Guest
Posts: n/a

 1st Apr 2009
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?
>
>

Rick Rothstein
Guest
Posts: n/a

 1st Apr 2009
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?
>
>

Francis
Guest
Posts: n/a

 1st Apr 2009
try COUNTA(A1:A30)

--

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

Mike H
Guest
Posts: n/a

 1st Apr 2009
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?
> >
> >

Bernard Liengme
Guest
Posts: n/a

 1st Apr 2009
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
>
> --
>
> 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?
>>
>>

Glenn
Guest
Posts: n/a

 1st Apr 2009
Bernard Liengme wrote:
> So what's wrong with being a geek?
>

Or Greek, for that matter?

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Features