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

  • Thread starter Thread starter Roseanne
  • Start date Start date
R

Roseanne

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Circular reference, Indirect, and Sum 3
how do I create a formula to add up time on a time sheet 3
Sumproduct formula problems 2
How to SUM entire column, but only when adjacent cell is not empty 3
Vlookup with changing columns 2
MERGE 3 columns into 1 all text 2
Using COUNT in a spreadsheet 2
Can't Get Display to Go to Sleep 1

Back
Top