Typing =SUMPRODUCT({0.5,1,0.5},{4,3,2}) into a cell gives a result of 6. I’m trying to get the same result by putting {0.5,1,0.5} in cell A1, {4,3,2} in cell A2, and =SUMPRODUCT(A1,A2) in cell A3, but when I try this I get the #VALUE error in A3. Is there a way to carry out this SUMPRODUCT with the arrays being drawn from their own separate cells?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to sumproduct cell arrays?
- Thread starter hpr0009
- Start date
Excel Facts
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
