Function that gives the SUM minus 4 lowest numbers

[Guest]

Ok The SUM for each row is easy, How do I get each row to drop the lowest
value for the SUM,

 

[NickHK]

Damar,
=SUM(A1:F1)-MIN(A1:F1)

NickHK

 

[Guest]

If the actual question if more like the title and you want to exclude the 4
lowest values then...

=SUM(A1:A10)-SMALL(A1:A10, 1)-SMALL(A1:A10, 2)-SMALL(A1:A10,
3)-SMALL(A1:A10, 4)

 

[NickHK]

Jim,
Ahh, missed the 4 aspect. Thought it was too easy.

NickHK

 

[Guest]

=sum(A1:A10)-SUM(SMALL(A1:A10,{1,2,3,4}))

entered normally might be more enticing and is functionally equivalent.