Monthly total

  • Thread starter Thread starter RJH
  • Start date Start date
R

RJH

I would like to track a monthly total on a credit card. A running total of
the months purchases. It should reset at the beginning of each month and
track the new months balance. How would I go about this?

Thanks!

Bob Howard
 
Hi Bob
a little bit more detail would be helpful :-)
So some assumptions:
- row 1 is a header
- column a is a date and column B the amount

Now enter the following in C2:
=IF(A2<>"",B2,"")

in C3 enter the following:
 
Frank,
Sorry about not giving you enough details. Your formula works fine for
consecutive numbers (which of course I don't have).
But... Your formula sent me off in a different direction thought. What I
came up with (using your assumptions) was this:
=IF(AND(MONTH(A3)=MONTH(NOW()),YEAR(A3)=YEAR(NOW())),B3,"") in 'C' and then
=Sum(C:C) in 'D1'.
This way I can have the monthly total at the top of the page with the frozen
header.

Thanks for your help!

Bob Howard
 
Back
Top