Thread: copy formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vercingetorix.XIII[_2_] Vercingetorix.XIII[_2_] is offline
external usenet poster
 
Posts: 30
Default copy formula

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