Forum Discussion
Solved
Find the total sum of Multiple category of value.
Hey there, I've attached sheet with it. I am trying to figure out the total value of sales for a particular salesman of ST products based on criteria.. In the right side ST Products is given, and...
=SUMPRODUCT(($C$9=$J$7:$J$11)*(($K$7:$K$11=$P$8)+($K$7:$K$11=$P$9))*$L$7:$L$11)You can try SUMPRODUCT.
=SUMPRODUCT(($C$9=$J$7:$J$11)*(($K$7:$K$11=$P$8)+($K$7:$K$11=$P$9))*$L$7:$L$11)You can try SUMPRODUCT.