Thread: Function that gives the SUM minus 4 lowest numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
  
Posts: 415
Default 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,


Reply With QuoteReply With Quote