Here you go

=I6+F8-SUM(D8:D42)

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"MEDIC70736" wrote:

i HAVE A BEGINING BALANCE IN CELL I6, A NUMBER IN CELL F8 GETS ADDED TO THE
NUMBER IN CELL I6, THEN ANY NUMBERS PUT INTO CELLS D8 THROUGH D42 ARE
SUBTRACTED FROM THAT TOTAL NUMBER AND THE FINAL TOTAL SHOULD BE IN CELL I47.
I47 SHOULD BE A RUNNING BALANCE LIKE A CHECK BOOK