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,

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

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,

Ragdyer,
are you impling the sum can't be in the same column as of the name range?
if that's required, i guess i'll hv to use sum(b7:bwhatever) instead?

Thanks,

"Ragdyer" wrote:

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,

Every way I tried it, I get a circular reference, and I get 0 !

Don't you?

If you must have the formula in Column B, you could simply reference a cell
that is beyond any actual possibility of being exceeded.

=Sum(B7:B10000)
--
HTH,

RD

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

"Jeff" wrote in message
...
Ragdyer,
are you impling the sum can't be in the same column as of the name
range?
if that's required, i guess i'll hv to use sum(b7:bwhatever) instead?

Thanks,

"Ragdyer" wrote:

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,


=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,