Describe exactly how you created your dynamic named range.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Jeff" wrote in message
...
no.. they are not.

"Bob Phillips" wrote:

Perhaps it is all text values.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jeff" wrote in message
...
Hi all,
I have a dynamic name range in a column, say colA with name Test from
A7
to the end of the column. When I set A5 = sum(test), it always gives me
0.
Any idea why?

Thanks,