Thread
:
Indirect Function Doesn't like non-contiguous ranges
View Single Post
#
3
Don Guillett
Posts: n/a
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?
Reply With Quote