Balance Calculation

I am trying to do a running day today balance sheet and need the following to be a sum but for some reason it runs as circular reference, help please....

Invoice in Total Invoice out Total Total balance
C D E F

the sum i have tried is =SUM(C3+D3:D3-E3=F3)

Hi Michaela and welcome to the forum,

Circular Reference normally happens when you are putting your formula in a cell that is needed to calculate it. For example if you have in Cell A5 the formula of =Sum(A1,A2,A3,A4,A5) it would give you the error message. Note in the Sum formula above the cells are separated by a COMMA.

What were you trying to do with your Sum formula as you have no commas and some plus signs...

If you want to sum a range of cells you would write =Sum(A1:B3). This notation with the colon between the cells tells Excel to add the whole range. That would be the same as =Sum(A1,A2,A3,B1,B2,B3).

I hope this helps...

Welcome to the Board but please note your initial thread title fell foul of the Forum Rules.
Your post title should accurately and concisely describe your problem.
Use terms appropriate to a Google search.

On this occasion given first post etc I've modified on your behalf - going forward please bear the above in mind.

@MarvinP - as an experienced member of the community please use your discretion when replying to threads that would appear to fall foul of the community rules.

Might be an idea to post some numbers etc so we can see what you mean ?

I'm not sure if you are saying that Column E is to be a "fudge" figure such that C+D-E = F or whether in fact all cells (C:F) have values in them already and you're trying to adjust them all in some way.

In F3 put this formula
= C3 + D3 - E3

Does that do it?

If not you have Homework:
http://ptc.chuh.org/pdf/Basic%20Form...in%20Excel.pdf
http://spreadsheets.about.com/od/exc...el_formula.htm
http://spreadsheets.about.com/od/exc...mula_begin.htm