Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
update sheet name in conditional sum every month
I have files with monthly data. This data has different categories (columns). I am summarizing this data in a sheet using conditional sum. Now when new data comes in every month I have to go into each cell with these formulae to update the formula with new sheet name with new data. Is there any easier/faster/better way to do this? Here is an example of formula in one cell (obviously when I copy the formula excel gets rid of { brackets but those are there in the formula)......and I have formulae like this in about 40 cells that I need to update every month manually. =SUM(IF(Sheet1_Dec!$J$2:$J$2859=$A5,IF(Sheet1_Dec! $I$2:$I$2859=G$4,Sheet1_Dec!$G$2:$G$2859,0),0)) Thank you very much in advance. Sanjay -- sa02000 ------------------------------------------------------------------------ sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747 View this thread: http://www.excelforum.com/showthread...hreadid=501063 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
update sheet name in conditional sum every month
How about just Edit|Replace?
Depending on the name of the worksheet, you may need to include apostrophes around that name. sa02000 wrote: I have files with monthly data. This data has different categories (columns). I am summarizing this data in a sheet using conditional sum. Now when new data comes in every month I have to go into each cell with these formulae to update the formula with new sheet name with new data. Is there any easier/faster/better way to do this? Here is an example of formula in one cell (obviously when I copy the formula excel gets rid of { brackets but those are there in the formula)......and I have formulae like this in about 40 cells that I need to update every month manually. =SUM(IF(Sheet1_Dec!$J$2:$J$2859=$A5,IF(Sheet1_Dec! $I$2:$I$2859=G$4,Sheet1_Dec!$G$2:$G$2859,0),0)) Thank you very much in advance. Sanjay -- sa02000 ------------------------------------------------------------------------ sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747 View this thread: http://www.excelforum.com/showthread...hreadid=501063 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
update sheet name in conditional sum every month
Edit|Replace works great. I didn't realize Find looks in formulas too. Thank you very much. Sanjay -- sa02000 ------------------------------------------------------------------------ sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747 View this thread: http://www.excelforum.com/showthread...hreadid=501063 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
how can i secuire Sheet Same time Update the Pivot Table | Excel Worksheet Functions | |||
Update forumla in same cell on each sheet | Excel Discussion (Misc queries) | |||
update sheet on the web | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) |