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

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

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

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)

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

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

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


Regards,
Ryan----

--
RyGuy


"Bob Phillips" wrote:

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)

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