#### e_a_g_l_e_p_i

##### New Member

- Joined
- Dec 12, 2012

- Messages
- 23

option 1 In column B each entry is either debit or credit

option 2 In column D there are dollar amounts that are either (dollar amount) or dollar amount

Above is what I have to work with I am sure it can be done very easy in options 1 or 2

Here is what I need.

In column E I have a title "total charged"

In column F I have "total Payments"

In column G I have "Running Total"

In the easiest way I would like to keep a running total as I copy and paste data from my bank. So for each cell that there is either a debit in Column B I need that to appear in column E "Total charged".

I need the same in Column F for "total payments"

For each column E,F,G I want the whole column all the way down to be calculated as I add data.

So I will end up with 3 formulas that I can place in each column so I have a running total.

It doesn't matter to me if you use the negative values for charges and the positive values for payments or if you chose to use column B and use debit or credit.

The most important part is I want the formula to be active in all cells in each column E,F and G so as I add new data each month the cells I have marked "Total charged", Total Payments" and "Running Totals"

Now I know I have given a lot of info but I wanted you to have enough to figure out what I want to do. I will stop here and if anyone has questions I will be happy to answer them.

Thanks