Taking the greater cell value of 3 of 4 cells...

**jerharder5** · 04-09-2009, 09:29 AM

Hi, I'm in charge of updating stats for our homerun league and was wondering if you guys could help me out with something...if it's possible. I need to add 4 cells together but I need it to take the 3 highest of the 4 cells. The cell values are in cells K6, R6, Y6, and AF6 and the total goes in cell B6. Say for example K6 is 1300, R6 is 1250, Y6 is 950 and AF6 is 1150, I'd need it to drop Y6 and add the other 3. Is it possible in Excel to do a function like this?? Any help would be greatly appreciated. Thank you in advance.....

**zbor** · 04-09-2009, 09:30 AM

Like this?

=SUM(R6:U6)-MIN(R6:U6)

(only slect cells you need)

**DonkeyOte** · 04-09-2009, 09:33 AM

Using your references:

You could use

B6: =SUM(LARGE((K6,R6,Y6,AF6),{1,2,3}))

Or using zbors v logical approaching of summing all and removing MIN

B6: =SUM(K6,R6,Y6,AF6)-MIN(K6,R6,Y6,AF6)