New Balance

[jmickey15]

I have a spread sheet the calculate the new balance when you enter a payment.

I want to copy the new balance into cell J15 Balance

						Balance	$ 140,000.00
Date		Ck #		AMT		Balance
						$  140,106.95
				$         106.95		$  140,000.00
				$         100.00		$  139,900.00
				$         100.00		$  139,800.00	new balance
		How do you copy the new balance (Row I) into Cell J15

[#2]

A simple solution is a sum formula.  Since your example had column/row headings, I recreated.

In cell H1, enter the simple formula; =G5-SUM(E:E).  This subtracts everything in column E from the beginning balance, cell G5.  If check amounts are entered as negative, change formula to G5+SUM(E:E).

 

[#3]

Perfect, Thanks so much.