Find the Average, Maximum, or Minimum in Excel

Question

How do you find the average, maximum, or minimum in Excel?

Answer

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. 

For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3


If you need further assistance, please click the CTL Support Request button on this page

CTL Support Request

Details

Article ID: 7961
Created
Thu 12/29/22 2:12 PM
Modified
Fri 11/3/23 4:04 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.