Running total by date
 

I have to following table:

Date Amount Total
1-Jan-07 0:15 0:15
2-Jan-07 0:15 0:30
3-Jan-07 0:20 0:50
1-Feb-07 0:10 0:10
10-Feb-07 0:10 0:20
12-Feb-07 0:30 0:50
2-Mar-07 1:00 1:00
20-Mar-07 0:25 1:25
and so on

What formula do I use on column "C" so that it keeps a running total for
only that month (date being on column "A").

Regards
--
capt

Running total by date
 

Hi,

In C1 put the formula
=B1
Then in C2 put the formula
=IF(MONTH(A2)=MONTH(A1),B2+C1,B2)

Drag down as required

Mike

"capt" wrote:

I have to following table:

Date Amount Total
1-Jan-07 0:15 0:15
2-Jan-07 0:15 0:30
3-Jan-07 0:20 0:50
1-Feb-07 0:10 0:10
10-Feb-07 0:10 0:20
12-Feb-07 0:30 0:50
2-Mar-07 1:00 1:00
20-Mar-07 0:25 1:25
and so on

What formula do I use on column "C" so that it keeps a running total for
only that month (date being on column "A").

Regards
--
capt

Running total by date
 

Thanks Mike,
It works fine, just the job......cheers!
--
capt


"Mike H" wrote:

Hi,

In C1 put the formula
=B1
Then in C2 put the formula
=IF(MONTH(A2)=MONTH(A1),B2+C1,B2)

Drag down as required

Mike

"capt" wrote:

I have to following table:

Date Amount Total
1-Jan-07 0:15 0:15
2-Jan-07 0:15 0:30
3-Jan-07 0:20 0:50
1-Feb-07 0:10 0:10
10-Feb-07 0:10 0:20
12-Feb-07 0:30 0:50
2-Mar-07 1:00 1:00
20-Mar-07 0:25 1:25
and so on

What formula do I use on column "C" so that it keeps a running total for
only that month (date being on column "A").

Regards
--
capt