# Using SumProduct and Large funtion

#### 12geoff

##### New Member
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.

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Hi.

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

Give an example.

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

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

"Totals" is the named range.

Replies
1
Views
300
Replies
0
Views
270
Replies
10
Views
656
Replies
3
Views
318
Replies
2
Views
424

1,196,053
Messages
6,013,118
Members
441,749
Latest member
batel19

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back