Microsoft Excel can look complicated when you first open it. There are formulas, functions, charts, tables, and countless tools to explore. However, you do not need to learn everything at once.

A good way to start is by learning a few simple Excel functions that solve common problems. Once you understand how these functions work, you can build a strong foundation for more advanced spreadsheets.

In this guide, we will explore three introductory Excel functions: SUM, AVERAGE, and COUNT. Each one is easy to understand and useful in everyday spreadsheets.

Whether you are managing personal finances, tracking sales, analyzing grades, or organizing business information, these functions can save time and reduce manual calculations.

1. SUM Function

The SUM function is one of the most commonly used Excel functions. It allows you to quickly add numbers together.

Instead of manually calculating:

150 + 200 + 350 + 100

you can let Excel perform the calculation automatically.

Basic Syntax

=SUM(1, 2, …)

You can also use a cell range:

=SUM(A1:A5)

This tells Excel to add all the numbers from A1 through A5.

Example

Imagine you have the following monthly expenses:

Expense	Amount
Electricity	$50
Internet	$30
Transportation	$70
Groceries	$200
Other	$50

If the amounts are stored in cells B2:B6, you can calculate the total with:

=SUM(B2:B6)

Excel will return:

$400

Why SUM Is Useful

SUM is particularly useful when you have many numbers to calculate.

For example, instead of manually adding dozens of sales transactions, you can simply use:

=SUM(B2:B50)

If you later change one of the values, Excel automatically updates the total.

This makes SUM especially useful for:

• Monthly expenses
• Sales totals
• Business revenue
• Inventory quantities
• Student grades
• Budget calculations
• Financial spreadsheets

A Useful Tip

You can select a range of cells and use the AutoSum feature to quickly create a SUM formula.

Excel will often automatically detect the range of numbers you want to calculate.

2. AVERAGE Function

The AVERAGE function calculates the arithmetic mean of a group of numbers.

In simple terms, it adds the numbers together and divides the result by the number of values.

For example:

10 + 20 + 30 = 60

There are three numbers, so:

60 ÷ 3 = 20

The average is therefore 20.

Basic Syntax

=AVERAGE(1,2, …)

For a range of cells, you can use:

=AVERAGE(A1:A5)

Example

Suppose a student receives the following grades:

Subject	Grade
Mathematics	85
Physics	90
Chemistry	80
English	75
Computer Science	95

To calculate the average grade, you could use:

=AVERAGE(B2:B6)

Excel returns:

85

This is much faster than calculating the average manually.

When Should You Use AVERAGE?

AVERAGE is useful whenever you want to understand the typical value in a group of numbers.

For example, you can use it to calculate:

• Average monthly expenses
• Average sales
• Average grades
• Average product price
• Average working hours
• Average customer order value
• Average daily visitors

An Important Detail

AVERAGE generally ignores empty cells.

For example, if you have:

10

20

30

and one empty cell, Excel calculates the average using the three numbers rather than treating the empty cell as another zero.

However, a cell containing 0 is different from an empty cell. A zero is included in the calculation. This distinction can become important when working with financial or statistical spreadsheets

3. COUNT Function

The COUNT function is slightly different from SUM and AVERAGE.

Instead of adding or calculating the average of numbers, COUNT tells you how many cells contain numbers.

Basic Syntax

=COUNT(value1, value2, …)

For a range:

=COUNT(A1:A10)

Excel counts the cells in that range that contain numeric values.

Example

Imagine you have a list of sales:

Order	Sales
Order 001	$25
Order 002	$40
Order 003	$15
Order 004	$60
Order 005	$30

You can use:

=COUNT(B2:B6)

The result will be:

5

This tells you that there are five numeric sales values.

What Happens With Text?

COUNT only counts numeric values.

For example:

Cell	Value
A1	25
A2	40
A3	Ahmed
A4	15
A5	30

Using:

=COUNT(A1:A5)

returns:

4

The text Ahmed is not counted because it is not a numeric value.

Why COUNT Is Useful

COUNT can be useful when you want to quickly determine how many numerical entries you have.

For example:

• Number of recorded sales
• Number of completed numerical entries
• Number of products with prices
• Number of recorded grades
• Number of transactions
• Number of days with recorded data

Using the Three Functions Together

The real usefulness of these functions becomes clearer when you use them together.

Imagine you have a simple sales spreadsheet:

Product	Sales
Product A	$100
Product B	$150
Product C	$75
Product D	$200
Product E	$125

You could use three formulas:

Total Sales

=SUM(B2:B6)

Result:

$650

Average Sale

=AVERAGE(B2:B6)

Result:

$130

Number of Sales

=COUNT(B2:B6)

Result:

5

With only three formulas, you now know three important things:

Total: $650
 Average: $130
 Number of sales: 5

This is a simple example of how Excel functions can turn raw data into useful information.

A Simple Practice Exercise

If you are learning Excel, try creating this small spreadsheet yourself:

Day	Sales
Monday	50
Tuesday	75
Wednesday	100
Thursday	80
Friday	120
Saturday	90
Sunday	110

Now try to calculate:

1. The total sales
2. The average daily sales
3. The number of days with recorded sales

Your formulas should look like:

=SUM(B2:B8)

=AVERAGE(B2:B8)

=COUNT(B2:B8)

The results should be:

Total: 625
 Average: 89.29
 Number of days: 7

Try changing some of the numbers and watch how Excel automatically updates the results.

SUM vs. AVERAGE vs. COUNT

It is useful to remember the main purpose of each function:

Function	What It Does	Example
SUM	Adds numbers	Total sales
AVERAGE	Calculates the mean	Average sales
COUNT	Counts numeric values	Number of sales

A simple way to remember them is:

SUM = How much altogether?

AVERAGE = How much on average?

COUNT = How many numbers?

Final Thoughts

Learning Excel does not have to begin with complicated formulas.

SUM, AVERAGE, and COUNT are three simple functions that can already help you perform useful calculations in many different types of spreadsheets.

Start by practicing them with small datasets. Once you understand how cell references and ranges work, you can gradually move toward conditional functions, lookups, charts, dashboards, and more advanced Excel features.

The goal is not to memorize hundreds of functions. Instead, focus on understanding what each function does and recognizing when it can solve a problem.

With a solid foundation in these basic functions, learning more advanced Excel formulas becomes much easier.

Looking for a ready-to-use Excel template? Explore foxstore24.