Actually, I think I made a mistake.. I 'thought' it was not working
correctly, but turns out it is.

What in fact I was doing, was setting up a sheet to track scores. But, in
this league, we only count the top 4 scores. So, if there were 8
participants, I wanted to sum up the total of the top 4, or the largest
values in a groups of cells. Example, if the cells had:
4,5,6,7,10,10,10,10, and I wanted the top 4 scores, I should have a result
of 40 in this case. Yes, I wanted to include duplicates.

At first I thought the function was not working, but now on closer
inspection, it appears to be working exactly as I want.

Sorry for the confusion and any unnecessary work I caused with this
question.

pl


"pilaar39 - ExcelForums.com" wrote
in message ...
I am tryijng to sum the largest 4 values in a column of cells.

I used:
SUM(LARGE(A1:A10,{1,2,3,4}))
which seems to work fine in general,
however, if any of the top 4 largest values is the same, then it
yeilds an incorrect sum.

How can I overcome this failure? I need to include duplicate values in
my sum.