View Single Post
  #1   Report Post  
Mitch
 
Posts: n/a
Default 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?