Sum Product between dates

[Mike Baker]

I have a data set that comprises of 3 columns. Col A - Purchase order numbers (text), Col B - Date, Col C - Value. I have two reference dates in separate cells and two reference amounts in two other cells.

I need to interrogate the data and report the number of Purchase Orders between specific dates having values between the two reference amounts.

I have tried Sumproduct but without success so far. Would appreciate any help out there.

Thanks.

Mike

 

[Andrew Poulsom]

Maybe you have a mix of UK and US dates. If you format them as eg dd-mmm-yyyy do you see what you expect?