Solved Total three largest values from a selection of cells

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


See More: Total three largest values from a selection of cells

Report •

#1
September 30, 2013 at 12:53:40
✔ Best Answer
have you tried this:

=SUM(LARGE((B5,F5,J5,N5),{1,2,3}))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 30, 2013 at 13:00:20
Thanks for the quick response, much appreciated. Works as required,
Shouldn't mess around with formulas when I'm this tired, but I think the brackets was what was throwing me of.
Again many thanks

Report •
Related Solutions


Ask Question