summing maximum values

[DaveO]

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)

 

[Andrew Poulsom]

Try:

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

 

[DaveO]

Will do

Wow, that was a quick response!

Dave

 

[DaveO]

Great, that works perfectly,

Thanks a load

Dave

 

[Aladin Akyurek]

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?

 

[Brian from Maui]

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?

Aladin,

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

 

[Aladin Akyurek]

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?

Aladin,

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?

 

[DaveO]

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