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 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 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 row
message edited by tonygibb
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.
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
Yes (14) | ![]() | |
No (14) | ![]() | |
I don't know (15) | ![]() |