software

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: www.excelforum.com/member.php...oamp;userid=27747
View this thread: www.excelforum.com/showthread...hreadid=501063How about just Edit|Replace?

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

sa02000 wrote:
gt;
gt; I have files with monthly data. This data has different categories
gt; (columns). I am summarizing this data in a sheet using conditional sum.
gt; Now when new data comes in every month I have to go into each cell with
gt; these formulae to update the formula with new sheet name with new data.
gt; Is there any easier/faster/better way to do this?
gt;
gt; Here is an example of formula in one cell (obviously when I copy the
gt; formula excel gets rid of { brackets but those are there in the
gt; formula)......and I have formulae like this in about 40 cells that I
gt; need to update every month manually.
gt;
gt; =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))
gt;
gt; Thank you very much in advance.
gt; Sanjay
gt;
gt; --
gt; sa02000
gt; ------------------------------------------------------------------------
gt; sa02000's Profile: www.excelforum.com/member.php...oamp;userid=27747
gt; View this thread: www.excelforum.com/showthread...hreadid=501063

--

Dave Peterson


Edit|Replace works great. I didn't realize Find looks in formulas too.
Thank you very much. Sanjay--
sa02000
------------------------------------------------------------------------
sa02000's Profile: www.excelforum.com/member.php...oamp;userid=27747
View this thread: www.excelforum.com/showthread...hreadid=501063