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

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

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

Hans

On Jan 25, 11:17 am, "Bob Phillips" wrote:
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 ooglegroups.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- Hide quoted text -- Show quoted text -