# summing maximum values

#### DaveO

##### Board Regular
Is there a quick way to sum the 4 highest values out of 6 consequetive columns? eg if cols A thru F contained 2,4,6,1,3,5 the result would be 18 (sum of everything except values 1 & 2)

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Try:

=SUM(LARGE(A1:F1,{1,2,3,4}))

Will do

Wow, that was a quick response!

Dave

Great, that works perfectly,

Dave

What happens if we have:

3,4,6,1,3,5?

Put otherwise: Do you want to ignore the ties of Nth largest value, that's, the ties of the 4th largest?

What happens if we have:

3,4,6,1,3,5?

Put otherwise: Do you want to ignore the ties of Nth largest value, that's, the ties of the 4th largest?

I'm curious, sum without ties 3,4,6,5

Brian from Maui said:
What happens if we have:

3,4,6,1,3,5?

Put otherwise: Do you want to ignore the ties of Nth largest value, that's, the ties of the 4th largest?

I'm curious, sum without ties 3,4,6,5

The question is to "sum 4 largest".

The 4th largest is 3 which has 2 occurrences/tokens.

The issue is: Do we include all 3's or not in the desired sum? Most people overlook this like when they also overlook the ties of the Nth value itself in questions regarding 'top N' as in

Bob 100
Bill 90
Jane 80
Carol 80
Mary 70

Who is the 3rd best?

The final sum for my needs has to have 4 out of 6 values summed, so if the scores were 50,50,50,60,60,60, I would need to sum 60,60,60 and one of the 50's, and if all values were 50, the required sum would be 200 (50*4)

Dave

Replies
4
Views
275
Replies
4
Views
199
Replies
3
Views
319
Replies
1
Views
203
Replies
2
Views
112

1,216,380
Messages
6,130,287
Members
449,570
Latest member
TomMacca52

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