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