how to add up only certain cells
 

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?

how to add up only certain cells
 

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?

how to add up only certain cells
 

Put the scores in a column
Sort the column descending
Add the top 30
--
Gary''s Student


"Mitch" wrote:

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?