Function that gives the SUM minus 4 lowest numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ok The SUM for each row is easy, How do I get each row to drop the lowest
value for the SUM,
 
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)
 
=sum(A1:A10)-SUM(SMALL(A1:A10,{1,2,3,4}))

entered normally might be more enticing and is functionally equivalent.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to sum all data values in a row EXCEPT the lowest two 4
Multiple SUM's in a column 15
Formula Help Needed (Sum and If Then) 1
Sum Function When Formula Produces #N/A 2
Conditional Formating: MAX & MIN 3
Get 2 Lowest Numbers from 4 Cells? 1
Summarize areas 7
The lowest of all? 6

Back
Top