Discussion Locked

Find 3 min values out of a range

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a range with a list of values. I need a formula to find the total of the 3 lowest values. The answer needs to be in one cell. I thought I could use MIN(N1:Nx) and then subtract that value from the range but I thought wrong. Any takers?

3 replies

by dklippert

Data>AutoFilter will allow you to display the three lowest. This formula uses the Small function to show the three smallest.
="The three lowest values are "&SMALL($A$1:$A$10,1)&", "&SMALL($A$1:$A$10,2)&", and "&SMALL($A$1:$A$10,3)

This discussion is closed to new replies.