Wither a bit of a tweak

=SUMPRODUCT(--(ISNUMBER(MATCH(B1:B25,A1:A6000,0))),--(etc.))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


wrote in message
oups.com...
I have a question that I have not found an answer for;
I know sumproduct does this:
sumproduct((Range to Look in = This cell data)*(etc...)) or
sumproduct((A1:A6000=B1)*(etc...))

BUT will it do this?

sumproduct((A1:A6000=B1:B25)*(etc...))

Thanks,


Hans