Is this a sumproduct function?

Morning Everyone,

Can anyone help me, I have x2 tabs within my spreadsheet:

Sales & Material

On the sales sheet, when I select a customer (example, account number 1234)
I would like the sales sheet to show me the top 20 sales per material.
So the criteria will be looking at matching, 1. Account number (1234) & 2.material number


Sales sheet

Cell A1 has the account

Cell B1:B200000 has the materials (Yes 200,000 materials)

Cell C1:C200000 is where I would like the sum


Material sheet

Cell A1 Customer
Cell B1 Material
Cell C1 Quantity


Hope someone can help


Is this a sumproduct? if so can someone help

Kind regards
Alan




Is this a sumproduct function?

Quantity from materials sheet

Hi Dave, shall I email you a file?
Regards
Al