Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Have formulas for sums on a different worksheet update with new information
I have a big workbook which gets updated monthly. There is a summary
sheet in it where I need to sum the previous 3 months, previous 12, year to date and total. I do not want to have to go in manually every month and update it, is there a formula that I could put in that can do this for me? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Have formulas for sums on a different worksheet update with new in
You could probably work up something using Sumif but without knowing anything
about the layout of your workbooks, that pretty much limits the opportunity to respond. If you want to send me a simple sample with some specifics included, I might be able to show you how. -- Regards, Tom Ogilvy " wrote: I have a big workbook which gets updated monthly. There is a summary sheet in it where I need to sum the previous 3 months, previous 12, year to date and total. I do not want to have to go in manually every month and update it, is there a formula that I could put in that can do this for me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to make averages AND sums of one spreadsheet of information | Excel Worksheet Functions | |||
Detecting Duplicate Sums - Worksheet code | Excel Discussion (Misc queries) | |||
Need to update information from one worksheet to another automatic | Excel Worksheet Functions | |||
How do I run sums from one worksheet to another? | Setting up and Configuration of Excel | |||
copy worksheet ... formulas do not update | Excel Worksheet Functions |