How to, number of entries

[SS]

In cells C31 : F55 I have entries of either a value or a word or blank.
In cell Q39 I want to have the total number of entries for those cells.

So if 40 entries are made then the total to be 40, meaning it does not count
the blank cells.

Is there a simple formula for doing this.

thank you.

 

[Claus Busch]

Hi,

Am Thu, 15 Jul 2010 21:00:42 +0100 schrieb SS:

In cells C31 : F55 I have entries of either a value or a word or blank.
In cell Q39 I want to have the total number of entries for those cells.

=COUNTA(C31:F55)
or
=100-COUNTBLANK(C31:F55)
(C31:F55 are 100 cells)


Regards
Claus Busch

 

[SS]

Hi,

Am Thu, 15 Jul 2010 21:00:42 +0100 schrieb SS:


=COUNTA(C31:F55)
or
=100-COUNTBLANK(C31:F55)
(C31:F55 are 100 cells)


Regards
Claus Busch

Thank you Claus that worked perfectly.