I have an Excel 2007 spreadsheet that contains duplicates of the same work requests. I need to count the unique number of work requests based on other criteria but am struggling to do this.

For example:

a1 = 01/01/2011

a2=01/02/2011

c2=car

d2=wheel

=Sumproduct((Sheet1!b2:b5000>a1)*(Sheet1!b2:b5000<a2)*(Sheet1!c2:c5000=c2)*((Sheet1!d2:d5000=d2

Worksheet I am calculating data on has information such as:

Work Request Date Raised Vehicle Part Code

WR1365 01/01/2011 truck Exhaust E1234

WR1365 01/01/2011 truck Exhaust E1235

WR1365 10/01/2011 truck engine EG1234

WR1231 15/01/2011 bike chain C1234

WR137 12/01/2011 car wheel W1233

WR137 12/01/2011 car wheel W1235

I want the SUMPRODUCT formula to return that there is 1 Car Wheel query even though there are two rows on the worksheet. I cannot work out how to do this. I appreciate that this is a simple SQL query using MSAccess or the like but I am hoping to calculate this in MSEXCEL instead.

Can I please cancel my initial "Close Question" request as I agree with Rorya that it is appropriate that the experts get some points assigned to them due to their efforts.

Thanks