Resize Sumif formula parameters for added data
2007 (compatibility mode 2003)
Two sections of w/s
Top contains Sumif formulas
Bottom contains detail data which is Sumif'd in the top section
Data has been added to the bottom section.
All of the Sumif formulas contain (except for the Relative "A2"):
=SUMIF($A$68:$A$350,A2,$D$68:$D$350)
The new data range extends to 386
Therefore, the formula needs to be
=SUMIF($A$68:$A$386,A2,$D$68:$D$386)
I could use a Replace but I do not think that it is the smartest approach.
Plus I would have to calculate the number to replace. I have a variable in the code area for the
Row of the last data item.
Thoughts? TIA EagleOne
|