Excel 2007 : Lotus 123 to Excel Formula Conversion

[Pelajar]

My company is currently using Lotus123 and I wish to convert everything to Excel, this is one of the problem I am experiencing.

Under [Balance]:
=IF(C6<>C7,(SUM(E6:E$7)-SUM(F6:F$7))-SUM(G5:G$7),0)

I am getting a circular reference warning and the formula does not work. To be honest I don't even understand what C6<>C7 means...

The formula is supposed to add up all the accounts receivables from companies of the same name regardless of how i sort the data. I will post an excel file for you to fiddle with... Thank you in advance....

[gmahlert]

The formula says IF C6 is not equal to C7 THEN return these sums, if not return zero.

A circular reference means that a formula is referring to itself. The circular reference is in cell G6. If you look at the last sum in this formula, you can see that it sums the the range G5:G7, which of course includes cell G6.

=IF(C6<>C7,(SUM(E6:E$7)-SUM(F6:F$7))-SUM(G5:G$7),0)