Excel formula- 3 hightest values added

[81shelly]

Hi, if i have 4 cells down and want to find the sum of the highest 3 values what formula could I use?
like for example
2
2
3
1
and get excel just to add 2+2+3=7


Thanks in advance

 

[Lewiy]

=SUM(LARGE(A1:A10,1),LARGE(A1:A10,2),LARGE(A1:A10,3))

 

[barry houdini]

Hello shelly, welcome to MrExcel

Try

=SUM(A1:A4)-MIN(A1:A4)

or, especially useful if you wanted to sum the three highest values from a bigger range

=SUM(LARGE(A1:A4,{1,2,3}))

 

[81shelly]

Thanks guys thats brill it worked..