How do I select numbers to add?

[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

 

[Dave R.]

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

 

[Dave R.]

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

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

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

 

[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)

 

[dobball23]

Thanks! I am going to give that a try.

Tod