How to, number of entries

  • Thread starter Thread starter SS
  • Start date Start date
S

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.
 
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.
Click to expand...

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


Regards
Claus Busch
 
Claus Busch said:
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
Click to expand...

Thank you Claus that worked perfectly.
 
Back
Top