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)
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201

ADVERTISEMENT

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

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
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
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
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?
 

DaveO

Board Regular
Joined
May 1, 2003
Messages
52
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,481
Messages
5,596,393
Members
414,063
Latest member
N_Bates

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
Top