Credit and Debit sheet in ms excel

[buntybutt]

Hi......................
I want to get the following pic table set in ms excel which is actually i had formed in Ms Word, but there is problem with it calculating the values automatically. So i have decided to make this sheet in excel, but I dont know the formula to put into the last two cell to automatically calculate the same result.
I have uploaded the table.

[sandyinfinite]

Hey buddy what is your actual problem ?
To calculate
ser 2 3 rows?or
total last 2 ?

[jkmyoung]

I don't understand how you are running the balance. Shouldn't it be a single column instead of 2?

You need a starting balance (perhaps 0?) and then add the credits and subtract the debts for each don't you?

[dsatino]

I think your header referencing 'running' is a bit misleading. It looks to me like you're just capturing transactions and showing the sum of debits and credits at the bottom. If that's the case then you just need to use the Sum() function.

[twinnyfo]

And, why not just have one column under balance, which will either be positive if there is a credit or negative if there is a debit? That would be a standard methodolgy for this type of account.....