Count number of text rows???

L

LAS

I want to have the number of students in a class to automatically update
when I add or remove a row. In other words, I want the value for "count" to
always be correct. I see how I could do this by making an =row() column,
but that wouldn't be idiot proof. Any new row would have to have that value
added by the user. Is there any way to count rows that have no numeric
value in them?

Example

First Name Last Name
Alma Diderot
Mark Woolser
Amy Fleisher
Count 3
 
C

Claus Busch

Hi,

Am Mon, 3 Sep 2012 20:05:05 -0400 schrieb LAS:
Example

First Name Last Name
Alma Diderot
Mark Woolser
Amy Fleisher
Count 3

try:
=COUNTA(A:A)-1
-1 for the header


Regards
Claus Busch
 
L

LAS

Thanks so much!!!
That's not in the list of any of the formulas on the formula tab that I can
see. Should I have been able to find this myself?
I'm using Excel 2010

"Claus Busch" wrote in message
Hi,

Am Mon, 3 Sep 2012 20:05:05 -0400 schrieb LAS:
Example

First Name Last Name
Alma Diderot
Mark Woolser
Amy Fleisher
Count 3

try:
=COUNTA(A:A)-1
-1 for the header


Regards
Claus Busch
 
C

Claus Busch

Hi,

Am Tue, 4 Sep 2012 17:49:35 -0400 schrieb LAS:
That's not in the list of any of the formulas on the formula tab that I can
see. Should I have been able to find this myself?
I'm using Excel 2010

Formulas => Insert Function => Statistical


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top