Sumproduct and Ranges

H

hansjhamm

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
 
B

Bob Phillips

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

hansjhamm

Thanks Bob...I will give it a spin!

Hans

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)
Click to expand...
 
Top