Indirect function with Named multiple ranges

[Damian]

I found that when trying to apply the INDIRECT function to
a Named Range that defines a multiple selection range, it
doesn't work.

Does anybody know anything about this? Any patch? or
workaround?

Thanks!

 

[Jim]

Can you explain more clearly what you are trying to do? What is it that
"doesn't work"?

 

[Damian]

Hi Jim,
I'll try to be more clear:
Suppose you have two sets of numerical values. One set is
stored in cells A1 trough A10, and the other set is in
cells C1 trough C10.

I define a named range as follows:
Data=A1:A10;C1:C10

Case a)
The function:
SUM(INDIRECT("A1:A10;C1:C10"))
works fine.

Case b)
The function:
SUM(INDIRECT(Data))
returns an error

In my understanding, Case b) should work exactly as Case
a), but it doesn't.

Thanks Jim.

 

[Jim]

Perhaps you got Case a) to return the correct value, but I would have to see
it before I would believe. <g>

 

[Damian]

You just have to test it!

-----Original Message-----
Perhaps you got Case a) to return the correct value, but I would have to see
it before I would believe. <g>
--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays



.

 

[Jim]

With the naemd range enclosed in quotes, #REF! is returned; without the
quotes xl recognizes the range and returns #VALUE!.

Why not make it easy and tell us how your data is arranged, the type of
data, and what you are trying to achieve.