I don't know if I understand exactly what you're asking.

Might this be it?

Enter this is B1:
=SUM(A1:A100,C1,-D1)

Where your total cell (B1), which is adding Column A, will increase by the
number you enter in C1, and decrease by the number you enter in D1.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Patrick" wrote in message
...
I am creating a spreadsheet for my acount payables and recievables. I want
to
designate a cell to keep a total.
I need one cell whenever I add a figure it add to the total and another
cell
whenever I subtract a figure it will subtract from that same cell.