Solved Total three largest values from a selection of cells

tonygibb September 30, 2013 at 12:13:39
Specs: Windows 7

Hi, Been messing around with this for a while, and other than having many nested IF functions, I can not seem to make this easier. If any one has some ideas, I would be happy to be directed the right way. What I have is as follows Cells B5, F5, J5, and N5 are the cells that I require to total the 3 highest values The cells between these have values in them as well, otherwise I would use the array B5:N5 If B5 = 5, F5 = 8, J5 = 2 N5 = 3 then my total would be 16 If B6 = 4, F6 = 3, J6 = 2 N6 = 3 then my total would be 10 If B7 = 4, F7 = 4, J7 = 4 N7 = 4 then my total would be 12 If I were using an array then the formula would be as follows =SUM(LARGE(B5:N5,{1,2,3})) So from this I need to change the format from an array to a list of particular cells within the row message edited by tonygibb

• › [Solved] Total three largest values from a selection of cells Part 2
• › Excel If statement w/ text values from range
• › look up highest value from a diff spreadsheet
• › Excel-Grab a specific value from a worksheet
• › Copy Multiple values from Drop list to single cell
• › Require multiple value from a horizontal table
• › vba code to copy only the values from cells not formulas