Monthly total

[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

 

[Frank Kabel]

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:

 

[RJH]

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