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

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

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

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

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

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

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

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