Sep 29 2022 04:15 AM
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?
Sep 29 2022 04:51 AM
Solution=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.
Sep 29 2022 04:51 AM
Sep 29 2022 08:39 PM
Oct 03 2022 01:45 AM
Sep 29 2022 04:51 AM
Solution=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.