I am a high school golf coach making a spreadsheet for my golfers stats using
excell 2007. I need to be able to add the 4 lowest values in a data table
that are greater than 0
Ex.
75,76,77,78,79,0,0 are the values. I need a formula that will automaticly
ignore the zero's and add the 4 smallest values. In this case it would be
75,76,77,78.

Any help would be appreciated!
Thanks!