LinkBack URL
About LinkBacks
I am looking for a formula that will add together the highest value with the second highest and third highest.
The values will be in Row A to J.
The values will be from 1 to 10.
Is this possible?
Max formula to return total of highest, second highest and third highest value
I am looking for a formula that will add together the highest value with the second highest and third highest.
The values will be in Row A to J.
The values will be from 1 to 10.
Is this possible?
Try this...
=SUM(LARGE(A1:J1,{1,2,3}))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Do you mean columns A to J and is there a result per row?
Try ......
=LARGE($A$1:$J$10,1)+LARGE($A$1:$J$10,2)+LARGE($A$1:$J$10,3)
Not certain of the range you require
Hi Jon,
If your numbers are in A1 to J1 this formula will work
=SUM(LARGE($A$1:$J$1,1),LARGE($A$1:$J$1,2),LARGE($A$1:$J$1,3))
If you have a two dimension array like A1 to J10 then this will do ya.
=SUM(LARGE($A$1:$J$10,1),LARGE($A$1:$J$10,2),LARGE($A$1:$J$10,3))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you guys
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks