Hello all,
I am trying to formulate a function that will add up the top three items in column c based off of the top three largest items in column b. I tried using an index function associated with a couple of if and row functions but I could not get it to work. I have attached a document for explanation purposes. Any help would be greatly appreciated.
To sum up top 3 try this
=SUM(LARGE(B5:B11,{1,2,3}))
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
Yeah, but I'm not trying to add up the top three in column B. I'm trying add up the three amounts in column C based on the top three amounts in column B.
Ok, try this array formula
=SUM(LARGE(IF(B5:B11>=2000,C5:C11),{1,2,3}))
...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.
Actually, looking at the equation, it only works if my third lowest amount is 2,000. Is there any way to get around that if the lowest third amount changes? Also, would this work if there were duplicate top three amounts?
EDITED
Last edited by wongkey; 10-22-2014 at 02:05 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks