Vercingetorix.XIII wrote:
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


Hello,

For the first part of your question, use absolute references. For the
second part, say you have values such as "PE", etc. in column A, then
enter this in B1 and fill down:

=SUMIF('Flash Update'!$B$1:$B$20,A1,'Flash Update'!$D$1:$D$20)