Adding sum of minimum values in a range

[tdoyle]

I would like to know how to add the sums for multiple values in a large range.

For example, if I have these values each in a cell:

81
73
69
75
75
70

Is there a formula I can use to add up the totals of the 4 LOWEST values (ie: 69+70+73+75).

I do golf pools at work and use the top four scores of each team of players. It would be nice to plug in a formula to tally the lowest four of each range instead of doing it by hand.

Thanks in advance! I love Excel and am learning new fun stuff about it all the time!

TOM

[NBVC]

Try:

=SUMPRODUCT(--SMALL(A1:A21,{1,2,3,4}))