Harland,

The countif is a WOW.

Thank you,

Steven

"Harlan Grove" wrote:

"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))