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

entered normally might be more enticing and is functionally equivalent.

--
Regards,
Tom Ogilvy

"Jim Thomlinson" wrote:

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)
--
HTH...

Jim Thomlinson


"NickHK" wrote:

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

NickHK

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