Friday, June 1, 2012

yogi_Compute Balance Row By Row From Multiple Credit And Balance Columns

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #570    Jun 01, 2012     www.energyefficientbuild.com.

user Ijatinput said:
Help with a simple (but long) formula, please! 
Hi
I'm doing accounts with a spreadsheet.  Column B is credit, and colums C - Q are debits.  Please can someone tell me a simple formula to put in column T for the running balance, rather than typing it all out as in =SUM(T4+B5-C5-D5-E5 etc etc)
----------------------------------------------------------------------------------------

following is a solution to the problem