Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct arrays
Hello Excel Users and Experts,
With: Sumproduct((array1=condition1)*(array2=condition2) *(array3)) Can array1 be column A, array2 be column C and array3 be column B? Or does 2 have to be to the right of 1 and 3 to the right of 2? I could have swore I returned an array3 that was between 1 and 2 once upon a time, but today I "swore" because I could not make that work. Moved the array3 info to the right of 1 and 2, bingo, success. Thanks folks. Regards, Howard |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct arrays
They can be any columns--well, you can't use the whole column--but the order
isn't important. "L. Howard Kittle" wrote: Hello Excel Users and Experts, With: Sumproduct((array1=condition1)*(array2=condition2) *(array3)) Can array1 be column A, array2 be column C and array3 be column B? Or does 2 have to be to the right of 1 and 3 to the right of 2? I could have swore I returned an array3 that was between 1 and 2 once upon a time, but today I "swore" because I could not make that work. Moved the array3 info to the right of 1 and 2, bingo, success. Thanks folks. Regards, Howard -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct arrays
As Dave says, the order is irrelevant. But I'm curious with your statement "Can array1 be column A ...". As far as I'm aware the arrays can't be entire columns, only a parts of columns. Can you post the formula if using the entire column works? Thanks, -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=531727 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct arrays
Well, I regrouped with Dave and John's advice. It works as advertised... I
must of had my columns values screwed up or perhaps the lookup values...??? Rats!!! I'm smarter than this but went duhhhhh...here. Thanks Dave and John... will report back with the next brain cramp. <bg Thanks again. Regards, Howard "L. Howard Kittle" wrote in message . .. Hello Excel Users and Experts, With: Sumproduct((array1=condition1)*(array2=condition2) *(array3)) Can array1 be column A, array2 be column C and array3 be column B? Or does 2 have to be to the right of 1 and 3 to the right of 2? I could have swore I returned an array3 that was between 1 and 2 once upon a time, but today I "swore" because I could not make that work. Moved the array3 info to the right of 1 and 2, bingo, success. Thanks folks. Regards, Howard |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct arrays
Or maybe you used different sized ranges????
"L. Howard Kittle" wrote: Well, I regrouped with Dave and John's advice. It works as advertised... I must of had my columns values screwed up or perhaps the lookup values...??? Rats!!! I'm smarter than this but went duhhhhh...here. Thanks Dave and John... will report back with the next brain cramp. <bg Thanks again. Regards, Howard "L. Howard Kittle" wrote in message . .. Hello Excel Users and Experts, With: Sumproduct((array1=condition1)*(array2=condition2) *(array3)) Can array1 be column A, array2 be column C and array3 be column B? Or does 2 have to be to the right of 1 and 3 to the right of 2? I could have swore I returned an array3 that was between 1 and 2 once upon a time, but today I "swore" because I could not make that work. Moved the array3 info to the right of 1 and 2, bingo, success. Thanks folks. Regards, Howard -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with SUMPRODUCT and Arrays | Excel Worksheet Functions | |||
sumproduct, arrays affecting speed | Excel Worksheet Functions | |||
If condition is true return sumproduct of two arrays | Excel Worksheet Functions | |||
If condition is true return sumproduct of two arrays | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |