Adding Column and removing highest number

G

Guest

I have a column with 5 numbers in it they range from 75 to 110 and they are
in no order, how do I add the 4 lowest numbers to get my result. It needs to
skip the highest number.
 

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

Showing the top result from a range of cells 6
=average - eliminate the top and bottom number 5
Subtracting Values from a Ranked List 4
Excel finding top of range 1
Interesting situation help required!! 3
Add a number '1' next to highest number in column 3
display specific next highest value from a column containing multi 13
Formatting cells 2

Top