Take a look at the SUM function in help file. Assuming your data is in column F
=SUM(F:F)

If you're doing credits in F, debits in G, your formula would be:
=SUM(F:F)-SUM(G:G)

you can put these formula anywhere EXCEPT for within column(s) F or G since
that would create a circular reference.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jenhunley" wrote:

i am trying to set up a running balance for payroll I have charge in column c
and i want to keep a running total in column d how do i get it to add up and
where do i put the formula?