Use an array formula like

=SUM(LARGE(J1:J36,ROW(INDIRECT("1:30"))))

which you commit with Ctrl-Shift-Enter. Replace J7:J36 with your range, but
it cannot be full column like J:J

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mitch" wrote in message
...
I am taking a class where we have daily quizzes, but only the thirty best
scores are kept. I'm keeping a running tally of how I do on the quizzes
but
I've just hit the 30 quiz mark. Is there a way in excel to search an
entire
row of numbers and add up only the 30 greatest values?