| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total column daily
Hello I have a daily report. Every day I add a new line. Presently I have
the formula =SUM(B4:B22) but every day I go in and change the formula to include the next line. example tomorrow the the formula will read =SUM(B4:B23) Is there a faster way to do this so that it automatically updates without having to change the formula daily? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Total column daily
Do you have anything else in column B? If not, just use
=SUM(B:B) "Wanna Learn" wrote in message ... Hello I have a daily report. Every day I add a new line. Presently I have the formula =SUM(B4:B22) but every day I go in and change the formula to include the next line. example tomorrow the the formula will read =SUM(B4:B23) Is there a faster way to do this so that it automatically updates without having to change the formula daily? thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Total column daily
Where is the formula located?
Assuming in column B enter this in B23 =SUM(B4:INDEX(B:B,ROW()-1)) Inserted rows above this will be included. Gord Dibben MS Excel MVP On Fri, 30 Nov 2007 06:49:02 -0800, Wanna Learn wrote: Hello I have a daily report. Every day I add a new line. Presently I have the formula =SUM(B4:B22) but every day I go in and change the formula to include the next line. example tomorrow the the formula will read =SUM(B4:B23) Is there a faster way to do this so that it automatically updates without having to change the formula daily? thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Total column daily
Thank you My totals are in row 3
"Gord Dibben" wrote: Where is the formula located? Assuming in column B enter this in B23 =SUM(B4:INDEX(B:B,ROW()-1)) Inserted rows above this will be included. Gord Dibben MS Excel MVP On Fri, 30 Nov 2007 06:49:02 -0800, Wanna Learn wrote: Hello I have a daily report. Every day I add a new line. Presently I have the formula =SUM(B4:B22) but every day I go in and change the formula to include the next line. example tomorrow the the formula will read =SUM(B4:B23) Is there a faster way to do this so that it automatically updates without having to change the formula daily? thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Total column daily
In B3 and you are adding below that?
=SUM(B4:B65536) Gord On Fri, 30 Nov 2007 09:41:00 -0800, Wanna Learn wrote: Thank you My totals are in row 3 "Gord Dibben" wrote: Where is the formula located? Assuming in column B enter this in B23 =SUM(B4:INDEX(B:B,ROW()-1)) Inserted rows above this will be included. Gord Dibben MS Excel MVP On Fri, 30 Nov 2007 06:49:02 -0800, Wanna Learn wrote: Hello I have a daily report. Every day I add a new line. Presently I have the formula =SUM(B4:B22) but every day I go in and change the formula to include the next line. example tomorrow the the formula will read =SUM(B4:B23) Is there a faster way to do this so that it automatically updates without having to change the formula daily? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Daily Worksheet To Daily Invoice Total | Excel Worksheet Functions | |||
| I need a daily count sheet with a monthly total | Charts and Charting in Excel | |||
| need help with daily total | Excel Discussion (Misc queries) | |||
| Daily,monthly total | Excel Discussion (Misc queries) | |||
| updating data daily for a wk/month total | Excel Discussion (Misc queries) | |||
Linear Mode
