summing maximum values

DaveO

Board Regular
Joined
May 1, 2003
Messages
52
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.
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?
 
Upvote 0
Aladin Akyurek 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?

Aladin,

I'm curious, sum without ties 3,4,6,5
 
Upvote 0
Brian from Maui said:
Aladin Akyurek 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?

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?
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top