update sheet name in conditional sum every month

[sa02000]

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

[Dave Peterson]

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

[sa02000]

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