Function that gives the SUM minus 4 lowest numbers
 

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

Function that gives the SUM minus 4 lowest numbers
 

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,

Function that gives the SUM minus 4 lowest numbers
 

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,

Function that gives the SUM minus 4 lowest numbers
 

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

NickHK

"Jim Thomlinson" ...
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,

Function that gives the SUM minus 4 lowest numbers
 

=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,