Hi,

Am Tue, 26 Aug 2014 17:59:51 -0700 (PDT) schrieb :

I'm attempting the formula:
=SUMPRODUCT((A2:10="*"&A1&"*")*(B2:K2=B1))

in a SUMPRODUCT formula the ranges must have the same dimension:
=SUMPRODUCT(--(A2:A10=A1),--(B2:B10=B1))

Try it with COUNTIFS:
=COUNTIFS(A2:A10,"*"&A1&"*",B2:B10,B1)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional