copy formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vercingetorix.XIII - 31 Aug 2008 23:46 GMT

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

Reply to this Message

David Biddulph - 01 Sep 2008 00:00 GMT

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

> How do I get a formula to copy and keep same cell range? example:
>
[quoted text clipped - 8 lines]
>
> V.XIII

Reply to this Message

smartin - 01 Sep 2008 00:08 GMT

> How do I get a formula to copy and keep same cell range? example:
>
[quoted text clipped - 8 lines]
>
> 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)

Reply to this Message