# Excel Financial Formula - Can't get it to do what I want and it should be sooo simple

Discussion in 'Business Applications' started by sobroken, Apr 17, 2011.

Not open for further replies.

Joined:
May 11, 2002
Messages:
192
Hi Guys,

Apologies if this is unforgivably dumb but I don't use spreadsheets much and I just can't make it work.

I'm trying to make a home finances spreadsheet, where my first column is everything that comes in, and then I have five or six categorised columns for everything that goes out, ie bills, shopping, clothes etc.

What I would like is a nice neat formula that gives me a running total. So that would be yesterday's total+anything in today-anything out today. But the problem is that I have several "out" columns and I can't make it work when only one of them has a value. I have been using:

=SUM(L3;C4)-(D4:K4)

But I'm getting a !#VALUE! error with this, and even if I type the numbers of each individual negative cell, it will only subtract the first one. I know I can do this without typing each individual cell and without putting negative values in the cells.

Joined:
Apr 11, 2009
Messages:
5,467
First Name:
Josiah
Would it be possible to see a sample sheet? Obviously you don't want to share all your financial data with the world, but if you could make two or three lines of sample data that can help to explain what you're trying to accomplish.

Without that if I've understood it correctly
If L3 is the previous day's total
C4 is today's income
And D4:K4 encompasses today's expenditure

you could simply use the following in L4
=L3+C4-Sum(D4:K4)

Joined:
Jan 29, 2006
Messages:
5,333
Hi sobroken,
I've been using this monthly budget spreadsheet for a while now.
I've taken out real figures but you can have fixed income, variable expenses, and one-off expenses.It does all the maths for you. I found it on the web somewhere but can't recall where.
Any use?

Richard.

File size:
21.5 KB
Views:
34
As Seen On