Find the total sum of Multiple category of value.

[Shaqibiqbal007]

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 in the middle sales data is given..

Salesman suresh have done both the category of st product so i only want to add those values.

How to do that?

[#2 · Accepted solution]

@Shaqibiqbal007 

=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.

 

[#3]

=SUM(SUMIFS(L7:L11,J7:J11,C9,K7:K11,P8:P9))

[#4]

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?

[#5]

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.