copy formula

[Vercingetorix.XIII]

How do I get a formula to copy and keep same cell range? example:

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

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

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

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

 

[paulgu]

If you use $B$1:$B$20, when you copy the formula to another cell, it will remain as $B$1:$B$20. However to get the "PE" to change you will need to make it the reference to a cell containing "PE" without $s, e.g. Z1 or $Z1.
$Z1 will become $Z2 when copied to the next row down but will remain $Z2 when copied to a cell in another column in the same row.
HTH,
Paul