Hello,
Probably simple question here, but I am struggling with SUMIFS and SUMPRODUCT so I am reaching out for help. I have 3 columns: Two have values that need to be multiplied if a condition in the 3rd column is met. For simplicity, here is an example
<tbody>
</tbody>
The result would be 2*10 + 4*30 = 140. The actual sheet will have 2000 rows though. What is the easiest way to do this?
Thank you
Oscar
Probably simple question here, but I am struggling with SUMIFS and SUMPRODUCT so I am reaching out for help. I have 3 columns: Two have values that need to be multiplied if a condition in the 3rd column is met. For simplicity, here is an example
Value 1 | Value 2 | Criteria |
2 | 10 | Yes |
3 | 20 | No |
4 | 30 | Yes |
<tbody>
</tbody>
The result would be 2*10 + 4*30 = 140. The actual sheet will have 2000 rows though. What is the easiest way to do this?
Thank you
Oscar