Excel Range Names

T

trainer2000

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.
 
B

Bernie Deitrick

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)
 
Top