Excel 2002: How to sum up base on date parameters ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mr. Low - 27 Mar 2008 16:30 GMT

DEar Sir,

I have the following table:

A B C
1 Ref Date Amount
2 M12 12-02-08 200
3 T13 13-02-08 300
4 N26 14-02-08 450
5 Q64 15-02-08 500
6 K29 16-02-08 240
7 T47 17-02-08 220
8 B96 18-02-08 620
9 U74 19-02-08 210

If I wish to sum up in the following manner, may I know what formula must I
input
at D12 and copy down to get the answers ?

A D
SUMIF date earlier than Amount
12 19-02-08 XXX
13 16-02-08 XXX
14 14-02-08 XXX
15 10-02-08 XXX
16 05-02-08 XXX

Thanks

Low

Signature

A36B58K641

Reply to this Message

Jim Thomlinson - 27 Mar 2008 16:38 GMT

Something like this...

=sumif($B$2:$B$9, "<=" & A2, $C$2:$C$9)

Signature

HTH...

Jim Thomlinson

> DEar Sir,
>
[quoted text clipped - 26 lines]
>
> Low

Reply to this Message

Mr. Low - 27 Mar 2008 16:55 GMT

Hello Jim,

Thanks for your help.

Low

Signature

A36B58K641

> Something like this...
>
[quoted text clipped - 30 lines]
> >
> > Low

Reply to this Message

Dennis - 27 Mar 2008 16:43 GMT

=SUMIF(B2:B9,"<19-02-08",C2:C9)
You won't be able to copy this down unless your "date earlier than" is a
variable.

> DEar Sir,
>
[quoted text clipped - 26 lines]
>
> Low

Reply to this Message

Mr. Low - 27 Mar 2008 16:55 GMT

Hello Dennis,

Thanks for your help.

Low

Signature

A36B58K641

> =SUMIF(B2:B9,"<19-02-08",C2:C9)
> You won't be able to copy this down unless your "date earlier than" is a
[quoted text clipped - 30 lines]
> >
> > Low

Reply to this Message