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!

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

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