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

• › Require multiple value from a horizontal table
• › [Solved] Counting occurrences from a drop down list
• › [Solved] Macro to copy random rows keeping unique data from a 2nd Col
• › [Solved] How do I reference the value in a combo box in VBA macro
• › [Solved] Unique item counter plus total
• › [Solved] VBA code for finding partial/full match values!
• › [Solved] How can I get Adobe Reader to read documents from a webpage?