Formulas & Functions · ~4 min read

SUM, AVERAGE, MIN, MAX and COUNT in Excel

The five most-used functions, AutoSum and the status bar quick totals.

Video link coming soon
What you will learn

Step by step

1. Intro

Welcome back. In this lesson, you will learn the five functions that people use more than any others in Excel: SUM, AVERAGE, MIN, MAX and COUNT.

You will also learn AutoSum, a keyboard shortcut that writes a sum for you, and the quick totals that Excel shows at the bottom of the screen without any formula at all.

SUM, AVERAGE, MIN, MAX and COUNT in Excel: Intro
Intro

2. The data

Here are the monthly sales of seven people. Column B has the sales, and column C has the number of returned items, with a few gaps and one piece of text.

SUM, AVERAGE, MIN, MAX and COUNT in Excel: The data
The data

3. SUM

Let's start with SUM, the most used function in Excel. It adds up numbers. Click F2, and type equals SUM, open bracket, B2, colon, B8, close bracket.

Let's read it. The function name is SUM. Inside the brackets is the range, B2 colon B8, which means every cell from B2 down to B8. The colon means: from here to there.

The result is nine hundred and ten. Every function follows the same pattern: a name, then brackets, then the things you give it, called arguments.

=SUM(B2:B8)
SUM, AVERAGE, MIN, MAX and COUNT in Excel: SUM
SUM

4. AVERAGE

Next, AVERAGE. Click F3 and type equals AVERAGE, B2 colon B8. Average adds the numbers, and divides by how many there are.

The average sale is one hundred and thirty. Nine hundred and ten divided by seven.

=AVERAGE(B2:B8)
SUM, AVERAGE, MIN, MAX and COUNT in Excel: AVERAGE
AVERAGE

5. MIN and MAX

Now MIN and MAX. They find the smallest and the largest number. In F4, type equals MIN of B2 to B8. In F5, equals MAX of B2 to B8.

The smallest sale is eighty, and the largest is two hundred. This is a quick way to spot your best and your weakest result.

=MIN(B2:B8)
=MAX(B2:B8)
SUM, AVERAGE, MIN, MAX and COUNT in Excel: MIN and MAX
MIN and MAX

6. COUNT and COUNTA

Finally COUNT. It counts how many cells contain numbers. Click F6 and type equals COUNT, C2 colon C8. We use column C, because it has gaps and text.

The answer is five. COUNT counts only the numbers. It ignores the blank cell, and it ignores the text n slash a.

To count everything that is not empty, use COUNTA. In F7, type equals COUNTA, C2 colon C8.

That gives six: five numbers, plus the text. Only the truly empty cell is skipped. Remember: COUNT is for numbers, COUNTA is for anything.

=COUNT(C2:C8)
=COUNTA(C2:C8)
SUM, AVERAGE, MIN, MAX and COUNT in Excel: COUNT and COUNTA
COUNT and COUNTA

7. Separate cells

Sometimes the cells you want are not next to each other. Separate them with commas. In F8, type equals SUM, B2, comma, B4, comma, B6.

A colon means a range, and a comma means separate cells. That small difference matters a lot.

=SUM(B2,B4,B6)
SUM, AVERAGE, MIN, MAX and COUNT in Excel: Separate cells
Separate cells

8. AutoSum

Writing functions by hand is a good skill, but Excel has a shortcut for sums. Click B9, right under the numbers.

Press Alt and the equals key. Excel writes the SUM for you, and guesses the range above. Check that the dotted border covers the right cells, and press Enter.

AutoSum also lives on the Home tab, in the Editing group. It has a small arrow with more functions: Average, Count, Max and Min.

Shortcut: Alt + =

SUM, AVERAGE, MIN, MAX and COUNT in Excel: AutoSum
AutoSum

9. Quick totals

Now the no-formula way. Select the numbers in B2 to B8 and look at the status bar at the bottom of the window.

Excel shows the average, the count and the sum instantly. Nothing is written in any cell, so this is perfect for a quick check.

Right-click the status bar to add more, such as Minimum and Maximum. Choose what you want to see.

SUM, AVERAGE, MIN, MAX and COUNT in Excel: Quick totals
Quick totals

10. Live updates

Now the best part. Click B2, and change the first sale to one hundred and ninety. Press Enter.

Every function updated at once. The sum, the average, the largest value, even the AutoSum below. This is why we use functions instead of typing results.

SUM, AVERAGE, MIN, MAX and COUNT in Excel: Live updates
Live updates

11. Common mistakes

Here are three common mistakes. First, numbers stored as text are ignored by SUM, so check that your numbers are aligned to the right.

Second, a range that is too short. If you add a row, check that your range includes it. Third, COUNT versus COUNTA, which we saw a minute ago.

SUM, AVERAGE, MIN, MAX and COUNT in Excel: Common mistakes
Common mistakes

12. Recap

Let's recap. SUM adds. AVERAGE finds the mean. MIN and MAX find the smallest and the largest. COUNT counts numbers, and COUNTA counts anything that is not empty.

Remember Alt plus equals for AutoSum, and the status bar for quick checks. Next time, you will learn why formulas change when you copy them, and how the dollar sign locks a reference.

If there is something you want to learn next, write it in the comments. Your requests decide what we teach in the next tutorials. Thanks for watching, and see you in the next one.

SUM, AVERAGE, MIN, MAX and COUNT in Excel: Recap
Recap
What do you want to learn next? Tell us in the comments on YouTube: your requests decide the next tutorials.

← Previous tutorial: Save, Print and Share Excel Files (Beginner Tutorial)
Next tutorial: Relative vs Absolute References in Excel ($ Explained) →