| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
caculate the total for specific date
I would like to caculate the total in column A for those date more than 21
days until today in Column B, can anyone help? A B 200 1/3/2010 100 2/3/2010 200 2/3/2010 50 10/3/2010 80 25/3/2010 200 1/4/2010 60 3/4/2010 thanks a lot! -- Lowan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
caculate the total for specific date
Try;
=SUMIF($B$1:$B$10,"<=" & TODAY()-21,$A$1:$A$10) -- Regards Dave Hawley www.ozgrid.com "Lowan Chan" wrote in message ... I would like to caculate the total in column A for those date more than 21 days until today in Column B, can anyone help? A B 200 1/3/2010 100 2/3/2010 200 2/3/2010 50 10/3/2010 80 25/3/2010 200 1/4/2010 60 3/4/2010 thanks a lot! -- Lowan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| which numbers add up to a specific total | Excel Worksheet Functions | |||
| Total of a specific name | Excel Worksheet Functions | |||
| how to use today's date in a equation to caculate somebody's birth | Excel Discussion (Misc queries) | |||
| Function to caculate date | Excel Discussion (Misc queries) | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Hybrid Mode
