Running Balance shown problem

**jawwad321** · 01-26-2013, 05:41 AM

I have two bank account , and create running balance both of them,
I want to show TOTAL of my bank balance in another workbook in separate rows.
sorry for my bad English
sample sheet attached.

**dilipandey** · 01-26-2013, 06:34 AM

Hi Jawwad,

Welcome to the forum.

See the attached file where I have used below formula to obtain the desired results:-

Formula:

Please Login or Register  to view this content.

Bank Account.xlsx
Total Shows.xlsx

Regards,
DILIPandey
<click on below * if this helps>

**jawwad321** · 01-26-2013, 07:24 AM

Thanks for Reply
There is a little problem, If i add some Rows for transaction , it was never update automatically.
And if i only open Balance shows.xlsx the values not shown.
If possible please give me explanation about Formula.

Thanks & Best Regard

**dilipandey** · 01-26-2013, 07:28 AM

[
QUOTE]If i add some Rows for transaction , it was never update automatically.[/QUOTE]

You can have a vlookup formula in front of bank name in bank account workbook which will lookup the total amount from below data.. after this,you can get rid of 8 in formula

For offset function, suggest you to look into Excel in built help.

Regards,
DILIPandey
<click on below * if this helps>

**jawwad321** · 01-26-2013, 07:36 AM

Thanks for another reply Mr.DILIPandey
I will check this out Later.

Thanks & Best Regard.

**dilipandey** · 01-26-2013, 02:17 PM

okay.. np.

If your query has been resolved, suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey
<click on below * if this helps>