General discussion

Locked

Find 3 min values out of a range

By cyndeec ·
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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Find 3 min values out of a range

by DKlippert In reply to Find 3 min values out of ...

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)

Collapse -

Find 3 min values out of a range

by cyndeec In reply to Find 3 min values out of ...

Perfect! Thank you!

Collapse -

Find 3 min values out of a range

by cyndeec In reply to Find 3 min values out of ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums