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?