Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formula
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formula
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Copy Formula Down Without Changing Entire Formula | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Copy formula so destination displays formula as text | Excel Discussion (Misc queries) |