Thanks for all replies. You all have confirmed that the
indirect function won't operate on non-contiguous ranges.
Don, you are correct that entering the range directly
will work, but that prevents me from doing string math to
create the range names that I want. Sometimes we just
want to do more than the program will do. Thanks again
for your time. At least I know I hit a dead end.
-----Original Message-----
I don't think you can use indirect for this
=sum(rng1) will work

--
Don Guillett
SalesAid Software

wrote in message
...
I was trying to use the indirect command to sum a named
range of cells. If I enter the following in a cell then
the formula works if the text in the cell refers to a
contiguous range. If I change the range to be non-
contiguous, it gives a #ref error in the cell.
Cell contents
=+SUM(INDIRECT(I66))
I66 has the string "rng1" which is a named range on the
current worksheet.
Does anyone have any idea of any work around?


.