The Dougler

iTrader: (1)

I'm trying to build a spreadsheet to manage an account, I have debits(+) & Credits (-) columns and at the end of a bunch of transactions theres a total box which should add all the debits together minus all the credits to calcualte net gain/loss. the code i currently have for that box is: =SUM(E4+E5+E6+E7+E8+E9+E10+E11+E12)-(F4+F5+F6+F7+F8+F9+F10+F11+F12)
now i want to change the code so that i can freely add rows if necessary and the code will include those new rows. I thought that way to do that was =SUM(E4:E12)-(F4:F12) however when i change it to that i get the #value error.

I want to code to work so that i can add as many rows as i please between E4:E12 and it will automatically be added in the code for the total box. how would i go about doing this?

jlukja

have you tried
=SUM(E4:E12)-SUM(F4:F12)
?

The Dougler

iTrader: (1)

ha YES it works, you Sir are DA MAN!

Mizouse

could you post a screenshot of what you have going on? i have a work sheet to monitor my spending but its soo hard to keep track of my debits and credits cause its all under 1 column

The Dougler

iTrader: (1)

I use this to track expenses for a rental property i own. but the concept can work for you, I like using 2 columns because when you make entires you dont have to worry about + or - values, you just have to get the number in the right column.

Mizouse

ahh i see, but yea that was something i was looking for, 2 columns 1 for debits and one for credits

The Dougler

iTrader: (1)

I'm actually trying to set it up so that it will generate a income statement, balance sheet, statement of owners equity, and include a general journal so that all activities in any accounts are recorded. I didn;t like the quickbooks for mac so i thought i'd just program my own. i think in the end this will be about 15 sheets. there will be 12 of the above for each month of the year, followed by a balance sheet for the year end, statement of owners equity for the year end, and the journal entries for the entire year. Im trying to make this a general template so i can use it many times. And have this nicely organized makes things really easy at TAX time.

jlukja