How do I select numbers to add?

D

dobball23

I have an Excel spreadsheet with golf scores in it. I have 10 people i
hte list, but only the top eight scores count.

How would I make a formula to look at the 10 numbers and select th
lowest eight scores out of the list and add them up?

Thanks for the help!

Tod
 
D

Dave R.

Sorry, I misread -- thought you wanted the highest 8.. one small change (pun
intended);

=SUMPRODUCT(SMALL(A1:A10,ROW(INDIRECT("1:8"))))



Dave R. said:
=SUMPRODUCT(LARGE(A1:A10,ROW(INDIRECT("1:8"))))
Click to expand...
 
B

Bob Phillips

Hoi Todd,

Try this

=SUMPRODUCT(SMALL(A1:A10,ROW(INDIRECT("1:8"))))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top