Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
A brief explanation would be appreciated:
What is the difference between =sumproduct((A2:A100),(B2:B100)) versus =sumproduct((A2:A100)*(B2:B100)) I have been reading about the many uses of this function, and can not figure this out Thanks Paul |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
Paul,
The first formula lets the function multiply the two arrays together, as SP was designed to do. The second multiples the two arrays by use of the * operator and passes the resultant array to function as a single array, which SP can simply SUM the elements, so it does not use the product part of SP, just the SUM part. In that respect, it is redundant. The operators in SUMPRODUCT are usually used when conditional tests are introduced so as to resolve TRUE/FALSE arrays to 1/0 arrays that can be summed. Have you see this page http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH RP (remove nothere from the email address if mailing direct) "PA" wrote in message ... A brief explanation would be appreciated: What is the difference between =sumproduct((A2:A100),(B2:B100)) versus =sumproduct((A2:A100)*(B2:B100)) I have been reading about the many uses of this function, and can not figure this out Thanks Paul |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
Thank you Bob. I believe the third paragraph explained it perfectly.
"Bob Phillips" wrote: Paul, The first formula lets the function multiply the two arrays together, as SP was designed to do. The second multiples the two arrays by use of the * operator and passes the resultant array to function as a single array, which SP can simply SUM the elements, so it does not use the product part of SP, just the SUM part. In that respect, it is redundant. The operators in SUMPRODUCT are usually used when conditional tests are introduced so as to resolve TRUE/FALSE arrays to 1/0 arrays that can be summed. Have you see this page http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH RP (remove nothere from the email address if mailing direct) "PA" wrote in message ... A brief explanation would be appreciated: What is the difference between =sumproduct((A2:A100),(B2:B100)) versus =sumproduct((A2:A100)*(B2:B100)) I have been reading about the many uses of this function, and can not figure this out Thanks Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |