Subtract the lowest scores using the SMALL function.ĮXAMPLE: =SUM(D2:H2)-SMALL(D2:H2,1)-SMALL(D2:H2,2)

NOTE: This formula calculates the total of all scores in cells D2 through H2 and displays this result in the cell. In the row you want to calculate scores for, use the SUM function to total all the scores in the row. The SMALL function will return the n-th smallest value in the given range, where n is the number you specify.ĮXAMPLE: SMALL(D2:H2,2) will return the 2nd smallest value in the range. If you want to drop more than one low score, you will probably want to use the SMALL function. NOTE: This formula calculates the total of scores in cells D2 through H2, subtracts the lowest value in the range, and displays the result in the cell.ĭropping the Lowest Score: Multiple Score Option Subtract the lowest score using the MIN function. Use the SUM function to total all the scores in a selected range.

This function locates the minimum value in a range of scores.ĮXAMPLE: MIN(D2:H2) will return the smallest value in cells D2 through H2. In order to drop the lowest score, you will need to use the MIN function. Dropping the Lowest Score: Single Score Option A zero ( 0 ) is considered a value and can be dropped as the minimum value or smallest score and will be included when an average is calculated. WARNING: Blank or empty cells are ignored by the MIN, SMALL, and AVERAGE functions. For more information on entering formulas, refer to Calculating Other Functions above or Performing a Database Function ( Win | Mac). To calculate the total points while dropping two or more lowest scores, add the scores and then subtract the smallest and the next smallest values. You can drop a single score or multiple scores with Excel. Some instructors like to drop the lowest score(s) for each student to give an allowance for a missed quiz or a bad test-taking day.

How to sum a column in excel with zeros