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,

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.

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,

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,

RagDyer,
test=OFFSET(Sheet1!B7,0,0,COUNTA(Sheet1!$B:$B) -COUNTA(Sheet1!$B$1:$B$6),1)

in cell B5 = SUM(test)

Thanks,

"RagDyeR" wrote:

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,

Two things !

Take the formula [=Sum(test)] *out* of Column B.

Make the B7 reference *absolute*:

=OFFSET(Sheet1!$B$7,0,0,COUNTA(Sheet1!$B:$B)-COUNTA(Sheet1!$B$1:$B$6),1)


--
HTH,

RD

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

"Jeff" wrote in message
...
RagDyer,

st=OFFSET(Sheet1!B7,0,0,COUNTA(Sheet1!$B:$B) -COUNTA(Sheet1!$B$1:$B$6),1)

in cell B5 = SUM(test)

Thanks,

"RagDyeR" wrote:

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,

if you tried
=count(test)
what's returned.

If you see 0, then there are no numbers in that range.

And if you use:
edit|goto
type in Test
and hit enter

do you go to the range you expect?



Jeff wrote:

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,




--

Dave Peterson