One way:

=SUM(B13:B171)-SUM(C13:C171)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"DonnaR" wrote in message
...
I have a spreadsheet that I need a bank balance type of formula, and I can't
figure out what i am doing wrong.......

Column B: deposits
Column C: withdrawals
Column D: top cell only with account balance, a formula which ADDS any
amounts placed into column A, and subracts any amounts put into column B.

This is what I am using as my formula in the Column D cell, which is
obviously not correct: =+(B13:B171)-(C13:C171)