I can't get a column to automatically add up using the prescribed

[Roseanne]

I can't get a column to automatically add up using the prescribed formula.
It keeps telling me s'thing about 'circular?'

 

[RagDyeR]

You've probably entered the formula in a cell that is part of the sum range
itself.
--

HTH,

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

I can't get a column to automatically add up using the prescribed formula.
It keeps telling me s'thing about 'circular?'

 

[Bob Phillips]

That is because you are trying to include the formula cell in the formula
itself, like using =SUM(A:A) in say A10. The formula is referencing its host
cell, which is the circular reference.

Either use a range without that cell, or put the formula in an other column.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[ryguy7272]

Read this
http://exceltips.vitalnews.com/Pages/T002163_Dealing_with_Circular_References.html

This is worth a look too:
http://www.uwec.edu/help/Excel03/trshoot.htm


Regards,
Ryan----