| 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 |
| 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) | |||
![Vercingetorix.XIII[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
