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" <(E-Mail Removed)> wrote in message
news:F639764E-7830-49D5-825A-(E-Mail Removed)...
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" <(E-Mail Removed)> wrote in message
news:F639764E-7830-49D5-825A-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:F639764E-7830-49D5-825A-(E-Mail Removed)...
> >I can't get a column to automatically add up using the prescribed formula.
> > It keeps telling me s'thing about 'circular?'
>
>
>