Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating Sum Total
I have Month Total and Total to Date Row. My total to date update
automatically but my Month Total do not update automatically. Is it possible for to get Month Total updated automatically once I enter new rows of information. E. g A1 10000 A2 12000 A3 8000 a4 10000 - Lets say this is Aug Total Sum(A1:A4) $40000 A5 15000 A6 5000 A7 10000 A8 15000 - Sep Total Sum (A5:A8) $45,000 $85000 - Total to date Sum(A1:A8)- This updates automatically so I do not have problem with this. The Monthly total do not update automatically so I have to reference the cells for each new month once information is entered in the column. Is it possible to use the IF Statement or find last 4 rows of date before it sums so I can always get Total monthly update without doing this manually. I do this for multiple sheets and will totally appreciate all assistance. This affects my graph too. I have to update my graph across multiple sheets for newly monthly update Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating Sum Total
Use
=Subtotal(9,A1:A4) for monthly subtotals [change the range for each month once... if you insert rows it will adjust] For grandtotal use =Subtotal(9,A1:A100) or whatever range you have Subtotals skip any subtotal in the range... "Yossy" wrote: I have Month Total and Total to Date Row. My total to date update automatically but my Month Total do not update automatically. Is it possible for to get Month Total updated automatically once I enter new rows of information. E. g A1 10000 A2 12000 A3 8000 a4 10000 - Lets say this is Aug Total Sum(A1:A4) $40000 A5 15000 A6 5000 A7 10000 A8 15000 - Sep Total Sum (A5:A8) $45,000 $85000 - Total to date Sum(A1:A8)- This updates automatically so I do not have problem with this. The Monthly total do not update automatically so I have to reference the cells for each new month once information is entered in the column. Is it possible to use the IF Statement or find last 4 rows of date before it sums so I can always get Total monthly update without doing this manually. I do this for multiple sheets and will totally appreciate all assistance. This affects my graph too. I have to update my graph across multiple sheets for newly monthly update Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating a Running total from a cell | New Users to Excel | |||
Problem with summing formula updating Total... | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
updating data daily for a wk/month total | Excel Discussion (Misc queries) | |||
When updating a worksheet, how do I create a link updating the sa. | Excel Worksheet Functions |