Multiple formula for accounting excel 2003

[wakeup75]

I'm creating an accounting spreadsheet for my small business, I'm having trouble figuring out how to correctly create a formula. I use this formula: =SUM(E3,-F3,-G3,-H3,-I3) for each entry in a row to either credit or debit the line item into the ytd column which is J. But I also want the ytd column to show the correct and current value as each line item is entered. I can get this to happen if I click on J1 (which is actually the heading cell) and use the autosum feature it shows the correct running total in the heading cell. If I try to get it to work in any of the actual "working" cells in column J (the ytd total column) it seems to conflict with the formula shown above to get the correct amount positive or negative to show in the ytd total. I'm sure there's a way to make these formulas work together so that each row or line item is brought across correctly and the ytd column reflects the correct running total as each line item is entered.

[TheExcelphile]

Hi wakeup75!
Welcome to the forum!

Could you upload a sample sheet so we could help you better?

[wakeup75]

I have attached an the spread sheet, as you will see I'm getting the correct totals across the rows in the YTD column but I the YTD column to have the correct running total also.Business Spreadsheet.xls

[TheExcelphile]

Here you go.

I've kept the formula for J2 the same, and put in my formula from J3 onwards.
I hope this is what you were looking for.

Don't forget to click the little star to the left of this post if you feel I helped!

[wakeup75]

This is close but it only works correctly for the income column, if I put any values in any of the debit columns they don't work?

[TheExcelphile]

Sorry for the delay in replying to your question...

This is what you need. Again, I assumed that there would always be an income entry, which is why it wasn't working. It will work now for an entry in any column.