Q: Calculate the average for the first student in cell I8. The formula should drop the lowest score before calculating the average. Hint: You need to use three functions: SUM, MIN, AND COUNT. The first

student's assignment average is 94.2 after dropping the lowest assignment score.

A: Try this,
=(sum(b8:h8)-min(b8:h8))/(count(b8:h8)-1) .. Hope this helps.

batotoy|Points 1475|

Question

Asked 2/27/2013 3:25:37 PM

0 Answers/Comments

Rating

There are no new answers.

27,005,373 questions answered

There are no comments.