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

R

Roseanne

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

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?'
 
B

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)
 
Top