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

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