| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to apply date range criteria
I have this formula that works.
=SUMPRODUCT(--(Completed!E1:E4941="OTHER"),--(Completed!H1:H4941="COMPLETE"),(Completed!G1:G494 1)) It goes through three columns and looks for the specified criteria and retunrs the total number of days for COMPLETE project labeled as OTHER. That is fine but what I need to do now if get this result for a specific date range like from 07/01/2008 to 06/01/2009. I have tried a few different ways of doing this but all it does is return a value of 0. Can anyone help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to apply date range criteria
Just keep adding your criteria:
=SUMPRODUCT(--(Completed!E1:E4941="OTHER"), --(Completed!H1:H4941="COMPLETE"), --(Completed!x1:x4941=date(2008,7,1)), --(Completed!x1:x4941<date(2009,6,1)), (Completed!G1:G4941)) I used column X as the date column and included July 1, 2008, but excluded June 1, 2009. Nina wrote: I have this formula that works. =SUMPRODUCT(--(Completed!E1:E4941="OTHER"),--(Completed!H1:H4941="COMPLETE"),(Completed!G1:G494 1)) It goes through three columns and looks for the specified criteria and retunrs the total number of days for COMPLETE project labeled as OTHER. That is fine but what I need to do now if get this result for a specific date range like from 07/01/2008 to 06/01/2009. I have tried a few different ways of doing this but all it does is return a value of 0. Can anyone help! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to apply date range criteria
Thanks that worked! I knew it was something simple.
"Dave Peterson" wrote: Just keep adding your criteria: =SUMPRODUCT(--(Completed!E1:E4941="OTHER"), --(Completed!H1:H4941="COMPLETE"), --(Completed!x1:x4941=date(2008,7,1)), --(Completed!x1:x4941<date(2009,6,1)), (Completed!G1:G4941)) I used column X as the date column and included July 1, 2008, but excluded June 1, 2009. Nina wrote: I have this formula that works. =SUMPRODUCT(--(Completed!E1:E4941="OTHER"),--(Completed!H1:H4941="COMPLETE"),(Completed!G1:G494 1)) It goes through three columns and looks for the specified criteria and retunrs the total number of days for COMPLETE project labeled as OTHER. That is fine but what I need to do now if get this result for a specific date range like from 07/01/2008 to 06/01/2009. I have tried a few different ways of doing this but all it does is return a value of 0. Can anyone help! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif with date range criteria | Excel Worksheet Functions | |||
| Sum within a date range meeting one other criteria | Excel Worksheet Functions | |||
| How do I put a date range in the criteria of a countif formula? | Excel Discussion (Misc queries) | |||
| date criteria to select range | Excel Worksheet Functions | |||
| use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
Linear Mode
