Countif/sumproduct formula

[lorib01]

Hello,

Yesterday I got some great help with a problem (see http://www.mrexcel.com/forum/showthread.php?t=348357&goto=newpost) and I need some more today, please.

I have a sheet with repeated dates for several months and I need to break out data by week and then by certain criteria. I can do 1 or the other but combining the COUNTIF formula and the SUMPRODUCT formula has proven to be beyond me.

I have this now:

<code>=SUMPRODUCT(--(D2:D31719<="7/26/2008"+0),--(D2:D31719>"7/19/2008"+0),--(G2:G31719>"5"))</code>

but it returns a value of 0 which is incorrect.

What I need to do is have the formula return a sum of all of the fields in colG that are >5 within a date range. Once I find that # I have to divide it by another field and multiply by 100 to get the percent. It should be easy

I appreciate any help offered.

Thanks,

 

[hung2k]

Thanks for the quick reply but that's still returning a 0.

If it returns 0 here, means that there is no row matches your rule to sum up

 

[lorib01]

I think we are looking at this wrong which is probably my fault for not explaining myself well.

I need a count of every item in Col G that is greater than 5 (>5) but I need to sort it by the date range (hence the sumproduct). The SUMPRODUCT formula helped me separate the date range but I think it's a COUNTIF statement that would give me the count of G2:G31719 >5.

I hope that's clearer and thanks again for all of your help.