SUMPRODUCT Macro, Excel 2007 Help

[edgewild]

Hello excel experts,
I was wondering if someone could point me in the right direction on an issue I am having with an excel formula.

=SUMPRODUCT(--(INDIRECT("Data!A2:A1000")=A8),
--(INDIRECT("Data!B2:B1000")="Late load -  More than 2 hours late unless first stop")
+(INDIRECT("Data!C2:C1000")="2 hrs")
+(INDIRECT("Data!C2:C1000")="4 hrs")
+(INDIRECT("Data!C2:C1000")="6 hrs"))

Here is some sample data that I want to select in the above formula:
TestCompany, Late load - More than 2 hours late unless first stop, 2hrs
TestCompany, Late load - More than 2 hours late unless first stop, 4hrs
TestCompany, Late load - More than 2 hours late unless first stop, 6hrs

This however is also getting selected:
TestCompany, AnyValueHere, 2hrs

For lack of a better way of describing it I’ll use SQL syntax:

SELECT column1,column2,column3
FROM MySpreadsheet
WHERE column1='TestCompany' AND column2='More than 2 hours late unless first stop' AND 
column3 IN("2 hrs","4 hrs","6 hrs”)

Any help would be greatly appreciated.
Cheers!