summing name range in the same column with Dynamic name ranges
 

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,

summing name range in the same column with Dynamic name ranges
 

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.

summing name range in the same column with Dynamic name ranges
 

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,

summing name range in the same column with Dynamic name ranges
 

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,

summing name range in the same column with Dynamic name ranges
 

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

summing name range in the same column with Dynamic name ranges
 

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,

summing name range in the same column with Dynamic name ranges
 

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,

summing name range in the same column with Dynamic name ranges
 

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,

summing name range in the same column with Dynamic name ranges
 

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,