AVERAGE, MIN and MAX in Excel With Examples

Excel AVERAGE, MIN and MAX summarise a list in three numbers: the typical value, the smallest and the largest. All three use the same pattern, =FUNCTION(range), so once you know one you know them all. This guide uses a small call-centre table to show each function, how blanks and zeros change the answer, and the mistakes that come up in job tests.

What do AVERAGE, MIN and MAX do in Excel?#

AVERAGE returns the mean, MIN returns the smallest number and MAX returns the largest number in the cells you give it.

Each argument can be a single number, a cell or a range like B2:B6. You can list several ranges with commas, for example =MAX(B2:B6,D2:D6).

A worked example: a call-centre summary#

Here is a team's weekly data. Column B is calls handled and column C is the average call length in minutes.

Look at the fourth row. A shorter call means a faster agent, so the "best" time is the smallest number. Think about what "best" means before you reach for MAX.

How to use AVERAGE in Excel#

AVERAGE adds the numbers and divides by how many numbers there are. For the calls, that's 673 ÷ 5 = 134.6.

1. Click the cell for the result.
2. Type =AVERAGE( and select B2:B6.
3. Type ) and press Enter.

Averages often have long decimals. The average call length, =AVERAGE(C2:C6), is 6.84. To store it as 6.8, wrap it in ROUND: =ROUND(AVERAGE(C2:C6),1). The AVERAGE function reference has more examples.

You can also let Excel write it. Click the cell under the numbers, open the arrow next to the AutoSum button on the Home tab and choose Average. Excel guesses the range the same way the AutoSum shortcut does, so check it before pressing Enter.

Spell the name in full. AVG is not an Excel function and returns the #NAME? error.

How to use MIN and MAX#

MIN and MAX return a single number: the smallest or the largest in the range. They answer questions like "what was our lowest month?" or "what's the highest score?".

They return the value, not who it belongs to. MAX tells you the top call count is 165, but not that it was Amara. To fetch the name too, combine MAX with a lookup such as XLOOKUP or INDEX MATCH.

MIN and MAX also make a quick range, meaning the spread between the highest and lowest values. =MAX(B2:B6)-MIN(B2:B6) gives 68 calls. Interviewers like this question because it combines two functions in one formula.

If you need the second-highest value, or the top three, MAX is not enough. LARGE and SMALL find the top or bottom N values.

How do blanks, zeros and text affect the result?#

Empty cells and text are skipped, but zeros count. This difference changes answers more often than people expect.

Say Felix was on holiday. Here is what each possible entry in his cell does to the results:

An empty cell or text means "no data", so AVERAGE divides by 4 instead of 5. A 0 means "he handled zero calls", which drags the average down and becomes the new MIN. Leave a cell empty when there is no data, and type 0 only when the real value is zero. Not sure how many numbers your range holds? COUNT, COUNTA and COUNTBLANK tell you in one formula.

Two edge cases to remember:

• If the range has no numbers at all, AVERAGE returns #DIV/0!, because it can't divide by zero. MIN and MAX return 0.
• Numbers stored as text are skipped like any other text, so your average can be wrong without a warning.

When is AVERAGE the wrong choice?#

AVERAGE misleads when one value is far from the rest. One very large salary can pull the average of a small team well above what most people earn. That unusual value is called an outlier.

In that case the median, the middle value, is a fairer "typical" number. MEDIAN and MODE in Excel show how to find it, and AVERAGE vs MEDIAN explains which to report and why.

You may also need an average, minimum or maximum for only some rows, such as one region. Use AVERAGEIF, MINIFS or MAXIFS for that, covered in AVERAGEIF and AVERAGEIFS and MAXIFS and MINIFS.

Common mistakes with AVERAGE, MIN and MAX#

• Including the header or total row. =AVERAGE(B1:B7) might include a total in row 7 and push the average up. Start the range at the first data row and stop at the last.
• Using MAX for "best" when lower is better. Fastest time, lowest cost and fewest errors are all MIN questions.
• Averaging averages. The mean of two group averages is wrong when the groups are different sizes. Average the raw values instead.
• Typing values instead of cells. =AVERAGE(142,118,165,97,151) works today but doesn't update when the data changes. Point to the cells.

Practise it#

Practise AVERAGE, MIN and MAX in a live spreadsheet: you'll build the call-centre summary above, decide whether the fastest time is a MIN or a MAX, and write the spread in one formula. Then try the delivery-days exercise on this page.