How to display a list of brands of a specific supplier and sum up the number of items for the found supplier brands?

Question

excel

There is an export of the Bitrix database to Excel in which you can quite easily determine how many product names belong to the selected brand. There is also a correspondence table by which supplier specific brands are supplied. We set the task: to sum up the quantities of goods (their names) for a particular supplier. To do this, you need to find through the second table - which brands the supplier offers, then find the number of positions in our price list for the first brand, remember, repeat iteration, remember and add with the first and display the final amount. I have no idea how to do this...

Answer 1

How to display a list of brands of a specific supplier

Filter for the SUPPLIERS column.

and sum up the number of items for the found brands of the supplier?

In a few seconds it is done: https://exceltable.com/funkcii-excel/funkciya-summ...