Hi there, may someone can help me with this, what i have is a formula to return the sum of the 2 highest values. if possible i need to change the formula tu also return a single value if there is just that one value, on the attached file on sheet 1 is what i have and on sheet 2 is what i will like it to be, i have values on the row range 3:9 and want to have the sum of the to highes values or the just one single value on the range of cels M3:M9 Eg. M9, I have attached a file for a better reference, many thanks for any help.
Bookmarks