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!