![]() |
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 |
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 |
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