# 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 followsCells B5, F5, J5, and N5 are the cells that I require to total the 3 highest valuesThe cells between these have values in them as well, otherwise I would use the array B5:N5If B5 = 5, F5 = 8, J5 = 2 N5 = 3 then my total would be 16If B6 = 4, F6 = 3, J6 = 2 N6 = 3 then my total would be 10If B7 = 4, F7 = 4, J7 = 4 N7 = 4 then my total would be 12If 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 rowmessage edited by tonygibb See More: Total three largest values from a selection of cells

#1 September 30, 2013 at 12:53:40 September 30, 2013 at 13:00:20 