sum and omit 3 lowest numbers

C

chris

i need to add a column of numbers but have to omit the 3
lowest numbers. how would i do this?
 
F

Frank Kabel

Hi
one way:
=SUM(range) - SMALL(range,1) - SMALL(range,2)- SMALL(range,3)

or
=SUMIF(range,">" & SMALL(range,3))
though this can cause problems if you have duplicate values for the
lowest 3 numbers
 
C

Cecilkumara Fernando

Chris,
try this formula
=SUM(H3:H21)-SUM(SMALL(H3:H21,{1,2,3}))
change H3:H21 to suit your range
HTH
Cecil
 

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

Merge Excel file into Word Document 3
Findiing highest and lowest in rows and columns 3
Extract the 2 Lowest % 3
INDEX MATCH SMALL 13
Trying to subtract the two lowest values from a row of numbers 4
Replacing the lowest number with a popup input 0
Need help with a formula 3
How can the font and size of (all) citation numbers be altered? 1

Top