Hello All:
I am having a hard time using the sumproduct function and could use some help figuring out what I'm doing wrong. Currently, here is what I have in the cell:
=SUMPRODUCT((A2:A1000="1"),($B$2:$B$1000),($C$2:$C$1000))
What I want to happen is have excel search A2:A1000 and wherever there is a 1 in column a, multiply the number in the corresponding b cell in that row by the c cell in that row and then add all of these products together. For example, say there is a 1 in a1 and a6. I want excel to see the 1 in both cells and do the following: (b1*c1)+(b6*c6). I know I have set this up wrong right now, but I've tried using an array function with an if and I keep getting zero. I think sumproduct might be the proper function to use, but I'm not sure right now.
Thanks!
I am having a hard time using the sumproduct function and could use some help figuring out what I'm doing wrong. Currently, here is what I have in the cell:
=SUMPRODUCT((A2:A1000="1"),($B$2:$B$1000),($C$2:$C$1000))
What I want to happen is have excel search A2:A1000 and wherever there is a 1 in column a, multiply the number in the corresponding b cell in that row by the c cell in that row and then add all of these products together. For example, say there is a 1 in a1 and a6. I want excel to see the 1 in both cells and do the following: (b1*c1)+(b6*c6). I know I have set this up wrong right now, but I've tried using an array function with an if and I keep getting zero. I think sumproduct might be the proper function to use, but I'm not sure right now.
Thanks!
Last edited: