In your first message you said:

Now I define (the range A1:A10 is selected) a named range MyRange
=$A$1:$A$10

My suggestion was for that, not for a dynamic range.

Arvi Laanemets wrote:
Hi


"Debra Dalgleish" wrote in message
...

What do you get on the worksheet if you enter the formula:
=SUM(MyRange)


It returns the sum, of course

Btw. =SUM(INDIRECT("MyRange")) returns an error when the named range is
dynamic, like
MyRange=OFFSET(Sheet1!$A$1,,,COUNTIF(Sheet1!$A:$A, "<"),1)
With non-dynamic named range INDIRECT works.




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html