To keep the cell references unchanged, look at the difference between
absolute and relative addressing. (Excel help will explain it.)
If you want the "PE" to pick up a value from a cell, just replace "PE" by
the reference of the cell (keeping the reference relative if you want it to
change as you copy it down).
--
David Biddulph

"Vercingetorix.XIII" wrote in
message ...
How do I get a formula to copy and keep same cell range? example:

=SUMIF('Flash Update'!B1:B20,"PE",'Flash Update'!D1:D20)

when I copy it to another cell it comes out as:

=SUMIF('Flash Update'!B2:B21,"PE",'Flash Update'!D2:D21)

I'd like it to stay same range and if possible update the "PE" to whatever
"x" I need instead of having to edit each one manually...

V.XIII