Why not juts use a range bigger than you would ever need?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...
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