Sum 3 Largest Numbers
Daily Dose of Excel by Dick Kusleika http://www.dicks-blog.com/
=SUM(LARGE(A1:A10,{1,2,3}))
or
{=SUM(LARGE(A1:A10,ROW(INDIRECT("1:3"))))}
Must be entered as array. (Push Ctrl, Shift and Enter simultaneously)
You can also do it with criteria also like below.
{=SUM(LARGE(IF(A1:A10=A1,B1:B10,""),{1,2,3}))}
Must be entered as array. (Push Ctrl, Shift and Enter simultaneously)
or
{=SUM(LARGE(IF(A1:A10=A1,B1:B10,""),ROW(INDIRECT("1:3"))))}
Must be entered as array. (Push Ctrl, Shift and Enter simultaneously)