Formula help
 

I have a workbook that has several sheets for calculating information. I am
trying to set the formulas to count even if there are more rows added at a
later date. How do I set the formula to count the whole column?

Formula help
 

One way:

=COUNT(A:A)

In article ,
balterson wrote:

I have a workbook that has several sheets for calculating information. I am
trying to set the formulas to count even if there are more rows added at a
later date. How do I set the formula to count the whole column?

Formula help
 

=SUM(A:A) entered in B1


Gord Dibben MS Excel MVP

On Tue, 6 May 2008 10:08:01 -0700, balterson
wrote:

I have a workbook that has several sheets for calculating information. I am
trying to set the formulas to count even if there are more rows added at a
later date. How do I set the formula to count the whole column?

Formula help
 

ooops!

You did say 'Count"


Gord

On Tue, 06 May 2008 11:15:13 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

=SUM(A:A) entered in B1


Gord Dibben MS Excel MVP

On Tue, 6 May 2008 10:08:01 -0700, balterson
wrote:

I have a workbook that has several sheets for calculating information. I am
trying to set the formulas to count even if there are more rows added at a
later date. How do I set the formula to count the whole column?