Using SumProduct and Large funtion

[12geoff]

I have 3 columns of data.
Location, Units Sold and Product
There are over 150 locations selling 7 different kinds of product.
Each row summarizes amount of particular product sold per location.
I need to find the average of the top 20 sellers by Product
Be nice to have a formula to do this rather than chopping up the sheet.
I've been trying to use the Large function combined with SumProduct.
Having trouble.

 

[PaddyD]

Hi.

"I need to find the average of the top 20 sellers by Product "

Give an example.

 

[nbrcrunch]

=SUM(LARGE(Totals,{1,2,3}))

The above is a sample of summing the top three largest totals.

"Totals" is the named range.