Hi guys,
Currently having a problem combing vlookup and sumif. In the attached worksheet I'm trying to auto-generate the sum of the smallest three rankings for each country.
I've got to do this for other categories, so any help much appreciated.
Cheers
Shane
Please see attached file with formula.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Formula:
Please Login or Register to view this content.
CSE formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Last edited by humdingaling; 05-24-2015 at 09:39 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Duplicate thread:
http://www.excelforum.com/excel-gene...est-three.html
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
shanekerr, you posted the same question twice about 10 minutes apart. Both threads had responses so I merged them. There have been hiccups on the board today so maybe this was accidental, but please be aware that we have a rule against duplicate posts.
Carry on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks