Find the Average, Maximum, or Minimum in Excel

Use the AVERAGE, MAX, OR MIN functions. 

  1. Click your mouse in the cell in which you wish your result to appear 
  2. Click the arrow next to AutoSum on the Home Tab or the Formulas Tab
  3. Click the Average, Max, or Min 
  4. Highlight the range of cells you wish to find the value for 
  5. Press Enter 

 
To see more functions, click More Functions on the AutoSum list on the Home Tab to open the Insert Function dialog box OR go to the Formulas Tab and click on the More Functions orange textbook icon.

Print Article