Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|