Lets say that the cell J3 is a sum of three other cells (eg j4,j5 & j6), and
the circular reference occurs in j5.

As in my previous example, let's say that P3=G3+j3+N3. Although the values
in G3,J3 and N3 are greater than 0, P3 returns a zero value.

Is the main cause the circular reference? Or is there a problem with Excel
:) ?

Rgds
Mike tan


"Ms-Exl-Learner" wrote:

In which cell you are applying the formula? The circular reference will
occur when the formula intersect with the current cell on which you are
applying the formula.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Mike Tan" wrote:

Hi,

I'm having problems with Excel 2007

When I total up a number of cells, the value that is shown is 0. For
instance, totalling G3+j3+N3, I get 0. The referenced cells have values
greater than zero

Note: There is a notification of circular reference in one of the cells.
However, I never encountered such a problem with previous versions of excel
(zero value)

Rgds
Mike Tan