Thanks Guys it sorted now.

<q
As Paul Corrado advised in microsoft.public.excel.worksheet.functions

Try this in Cell A6. I think it will work

IF(B7Sum(a1:a5),Sum(a1:a5)-b7,0)
</q

MahaRaj



"MahaRaj®" wrote in message
...
HI
I am making a Trial Balance. and getting a circular ref as below.


.................A.................B
1.... .........15...............16
2 .............15...............17
3..............13...............13
4..............13...............33
5..............22...............33
6 I have put a formula in A6. IF(B7A78,A8,0) and in B6. IF(B7A78,0,A8)
You know what I mean
7 Totals....78.............112
8 Diff.......34 (=a7-b7)

So the totals should be 112 in both cells (A8 and B8)

Could you please give me any tips.
Thanks.