ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sumproduct and Ranges (https://www.excelbanter.com/excel-discussion-misc-queries/127676-sumproduct-ranges.html)

[email protected]

Sumproduct and Ranges
 
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


Bob Phillips

Sumproduct and Ranges
 
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




[email protected]

Sumproduct and Ranges
 
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 -




All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com