VLOOKUP ignoring duplicate values

[Skipmeok]

Hello -- This is my first post and I'm having trouble with this formula. Whats going on is there are 10 values in column "A" and 10 values in column "B". I'm using VLOOKUP and LARGE to find the largest 5 values in column "A" then add the corresponding 5 values from column "B". However, if column "A" has duplicate values, it only uses the first one it finds and thus throws off the total for column "B".

"A" "B"
257 3
250 4
227 5
231 3
249 6
250 1
219 4
264 3
233 2
197 1

So my 5 highest values in "A" are: 264, 257, 250, 250, 249 and column "B" are: 3, 3, 4, 1, 6 so the total for "B" should be: 17, but because it reads the first 250 twice, I get 20.... Can someone please help?

Skipmeok

 

[godsaaint]

This should work:

=SUMIF(A1:A10,">="&LARGE(A1:A10,5),B1:B10)

 

[Skipmeok]

I can't thank you enough... I need to take some Excel classes and get up tp speed with these formulas. Again, thank you so much!!