Forum Discussion
Solved
Find the total amount value based on different category Products for a specific salesman
Hey there. I am attaching a workbook which is having three different sheets. 1. Raw Data 2. Employee details 3. ST Products Here I am trying to find the total ST ACT of a particular salesman bas...
An advantage of using SUMIFS is that you do not need to search for each product individually. If you have a list of products,
= SUM( SUMIFS( Sales[Amount], Sales[Sales Person], Employee, Sales[Category], productList ) )SUMIFS will return an array, which is then summed for an individual Employee.
Other differences include converting the raw data to a table and using defined names for the list of products and an individual employee.
Thanks you got your point.. Can you tell me how do i same if i want to get the total amount of salesman but excluding ST Products this time.
You would either need a complete list of products to include or use the figure you already have and subtract it from the total sales for the salesman.
- omg thankkkss alottt sir..