Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Range Names
I am trouble shooting a worksheet for a colleague. She receives a work sheet
with formulas that are created by using range names. She wants me to delete the range names and supplement the cell addresses. One of the formulas is a SUMIF. The value in the criteria field changes with each cell. When I try to copy the formula using the cell addresses it will not work. Is it necessary to do each cell by hand or is it possible to recalculate a range at a time. I have tried the manual calculation as well and it is not working. Any help would be appreciated. -- Tech Trainer |
#2
|
|||
|
|||
Tech Trainer,
IF the SUMIF formula is something like =SUMIF(RangeName1,A1,RangeName2) then you need to replace the RangeNames with their range addresses using absolute addressing, along the lines of: =SUMIF($A$1:$A$10,A1,$B$1:$B$10) -- HTH, Bernie MS Excel MVP "trainer2000" wrote in message ... I am trouble shooting a worksheet for a colleague. She receives a work sheet with formulas that are created by using range names. She wants me to delete the range names and supplement the cell addresses. One of the formulas is a SUMIF. The value in the criteria field changes with each cell. When I try to copy the formula using the cell addresses it will not work. Is it necessary to do each cell by hand or is it possible to recalculate a range at a time. I have tried the manual calculation as well and it is not working. Any help would be appreciated. -- Tech Trainer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel how do I delete or change the name of a range of cells? | Excel Discussion (Misc queries) | |||
Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
Paste a named range to another range in Excel | Excel Discussion (Misc queries) | |||
how can I count distinct names in an excel list? | Excel Discussion (Misc queries) | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel |