Am I missing something here?

What's wrong with ISNUMBER(MATCH(...))

--
Biff
Microsoft Excel MVP


"Harlan Grove" wrote in message
...
"ShaneDevenshire" wrote...
...
=SUMPRODUCT(($A$14:$A$30002=TRANSPOSE(B1:B3))*($ B$14:B$30002=$A$3)*
($C$14:$C$30002=$C$2)*($D$14:$D$30002))
...

Or as long as A14:A30002 don't contain wildcard characters,

=SUMPRODUCT(COUNTIF(B1:B3,$A$14:$A$30002)*($B$14:B $30002=$A$3)*
($C$14:$C$30002=$C$2)*($D$14:$D$30002))