I have two columns of values. I want to add up the product of the two values, where the 2nd is grater than 1.
Now I’m using a separate 3rd column to aid in this and sumif the values based on the x2 column.
=SUMIF(B1:B9, ">0", C1:C9)
| X1 | X2 | Prod |
|---|---|---|
| 4 | 3 | 12 |
| 4 | 4 | 16 |
| 5 | 1 | 5 |
| 6 | 0 | 0 |
| 10 | 4 | 40 |
The result in this case should be 12+16+40 = 68
Is it possible to do the same without the 3rd column?
>Solution :
Below should work
=SUMPRODUCT((A2:A6)*(B2:B6)*(B2:B6>1))