E
Eric
You might have your sum statement in a cell where it is
refrencing the cells to be summed, then you'll have a
circular refrence.
Example: Say you had wanted to sum the values in A1:A10
and you put the sum statement in A4. It should give you a
error stating that you have a circular refrence. To find
what it is refrencing, go to Tools - Auditing -
TracePrecidents.
refrencing the cells to be summed, then you'll have a
circular refrence.
Example: Say you had wanted to sum the values in A1:A10
and you put the sum statement in A4. It should give you a
error stating that you have a circular refrence. To find
what it is refrencing, go to Tools - Auditing -
TracePrecidents.