| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to sum up base on date parameters ?
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 -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to sum up base on date parameters ?
Something like this...
=sumif($B$2:$B$9, "<=" & A2, $C$2:$C$9) -- HTH... Jim Thomlinson "Mr. Low" wrote: 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 -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to sum up base on date parameters ?
Hello Jim,
Thanks for your help. Low -- A36B58K641 "Jim Thomlinson" wrote: Something like this... =sumif($B$2:$B$9, "<=" & A2, $C$2:$C$9) -- HTH... Jim Thomlinson "Mr. Low" wrote: 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 -- A36B58K641 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to sum up base on date parameters ?
=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. "Mr. Low" wrote: 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 -- A36B58K641 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to sum up base on date parameters ?
Hello Dennis,
Thanks for your help. Low -- A36B58K641 "Dennis" wrote: =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. "Mr. Low" wrote: 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 -- A36B58K641 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date for 2002 Excel.exe | New Users to Excel | |||
| Define a cell value base on the date | Excel Discussion (Misc queries) | |||
| Using parameters to use different source files dependant on the date. | Excel Discussion (Misc queries) | |||
| Warning message base on date | Excel Worksheet Functions | |||
| Help : Using Parameters with External Date Query | Excel Discussion (Misc queries) | |||
Hybrid Mode
