how to add up only certain cells

G

Guest

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?
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to Look for Text and then Perform Specified Actions 1
Can you only merge up to a certain number of cells 2
Protect Only Certain Cells 2
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
HOW TO TOTAL THE THREE HIGHEST AMOUNTS IN A ROW 2
Calculating Cells across worksheets?? 3
VBA to SUM only certain cells 2
how to sum 'n' largest values *not* in an array? 7

Top