How to apply date range criteria

[Nina]

I have this formula that works
=SUMPRODUCT(--(Completed!E1:E4941="OTHER"),--(Completed!H1:H4941="COMPLETE"),(Completed!G1:G4941))
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]

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]

Thanks that worked! I knew it was something simple.