How do I select numbers to add?

  • Thread starter Thread starter dobball23
  • Start date Start date
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
 
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"))))
 
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)
 
Back
Top