update sheet name in conditional sum every month

S

sa02000

I have files with monthly data. This data has different categorie
(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 wit
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 th
formula excel gets rid of { brackets but those are there in th
formula)......and I have formulae like this in about 40 cells that
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.
Sanja
 
D

Dave Peterson

How about just Edit|Replace?

Depending on the name of the worksheet, you may need to include apostrophes
around that name.
 
S

sa02000

Edit|Replace works great. I didn't realize Find looks in formulas too.
Thank you very much. Sanjay
 
Top