Off Balance...

**DonkeyOte** · 09-07-2009, 02:28 AM

OK so if we assume first formula in terms of running balance is to go into AF10 then:

AF10
=IF(COUNT($E10,$J10:$AE10),SUM($AF9,$E10)-SUM($J10:$AE10),"")
copied down to AF119

**artboyblue** · 09-07-2009, 02:38 AM

Thanks for your help. That worked. I revised the formula for next cell below like this:

=IF(COUNT($E11,$J11:$AE11),SUM($AF10,$E11)-SUM($J11:$AE11),"")

and it worked too. However, this is a huge table... please tell me there is an easier way than manually editing every cell in the balance column. This would be especially painful when adding new rows.

Thanks again for your assistance.

**DonkeyOte** · 09-07-2009, 02:43 AM

You can copy and paste AF10 into AF11:AF119 simultaneously - you need not apply each formula individually... (or if you hover on bottom right corner of AF10 you will see a black cross - click that and drag down to AF119).

You might want to google on "Fill Handle" as this is a very handy tool when you're getting to grips with XL.

**artboyblue** · 09-07-2009, 03:01 AM

Absolutely Astounding... I can't thank you enough. Worked like a charm. Thanks for being so patient, thorough, and quick to offer assistance... truly appreciated.