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.
=SUM(SUMIFS(L7:L11,J7:J11,C9,K7:K11,P8:P9))
Thankyou sooo much for this short method.. Can you please tell me how will i do that if i want to show the same but now this time excluding ST Products. Like i want to show the total amount of Suresh salesman who sold products which are not present in ST Product table?
- I would set up another table that contains non ST products and use the same method as before in a new cell. Not sure if there's a better way to do this? Maybe someone else has a better method.