I am trying to do a formula that does a multiplication instead of adding it, but there is no such function.
A B C
1 Value Quantity Department
2 $25 5 100
3 $10 6 200
4 $50 1 100
I need a formula that would, return $175 (5 x $25 + 1 x $50) if I want to get the values for department 100, and $60 (6 x $10) if I get the value for deparment 200.
I have more departments (100, 200, 300, 400, 500, 600, and 700), but the above is just an example.
Bookmarks