Find 3 min values out of a range - TechRepublic
General discussion
September 5, 2000 at 04:37 AM
cyndeec

Find 3 min values out of a range

by cyndeec . Updated 25 years, 9 months ago

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 discussion is locked

All Comments