Excel Range Names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Using SUMIFS with date range 4
SUMIF with NAME RANGE 1
Help! Names defined in Excel 2003 invalid in Excel 2007 3
Excel VBA setting Ranges 2
Named range labels in formulas 1
Vlookup using a reference to a named range?(Excel 2000) 4

Back
Top