How to Calculate Average: Formula, Steps & Examples

The average is the simplest way to sum up a set of numbers, but it can be skewed by extreme values. This guide shows how to calculate it step by step with examples and Excel functions.

Average formula: Sum ÷ Count ·
Common use: Central tendency of a dataset ·
Example (1,2,3,4,5): 15 ÷ 5 = 3 ·
Example (14,17,22,27): 80 ÷ 4 = 20 ·
Excel function: =AVERAGE(range)

Five example datasets, one pattern: the average formula gives a quick central value for any list.

The implication: once you master the sum-and-divide process, you can handle any dataset size.

What is an average formula?

The average formula explained

• Average = Sum of all values ÷ Number of values (Microsoft Support)
• Also known as the arithmetic mean (W3Schools)

This formula works for any set of numbers. Whether you’re averaging test scores, monthly expenses, or product prices, the process stays the same.

The trade-off: averages can be distorted by very high or very low values. When that happens, the median might be a better choice.

Sum of values divided by count

Breaking it down into two steps: first, add all the numbers in your dataset. Second, count how many numbers you added. Then divide the sum by that count.

For example, with the numbers 24, 55, 17, and 87, the sum is 183. There are 4 numbers, so the average is 183 ÷ 4 = 45.75 (Omnicalculator).

How do I calculate an average?

Step-by-step calculation method

1. Step 1: Add all the numbers in your dataset.
2. Step 2: Count how many numbers you added.
3. Step 3: Divide the sum by the count.

This three-step process works for whole numbers, decimals, fractions, and percentages (Calculator.net).

For a dataset like 14, 17, 22, 27, the sum is 14+17+22+27 = 80, the count is 4, and the average is 80 ÷ 4 = 20.

Example: average of 1, 2, 3, 4, 5

Take the numbers 1, 2, 3, 4, 5. Sum = 1+2+3+4+5 = 15. Count = 5. Average = 15 ÷ 5 = 3 (Calculator.net).

That’s the arithmetic mean for that set. The same method applies to any collection of numbers.

The pattern: the average formula scales from small to large datasets without change.

What is the average of 14, 17, 22, 27?

Calculating average for a small dataset

Let’s walk through these four numbers. Sum = 14 + 17 + 22 + 27 = 80. Count = 4. Average = 80 ÷ 4 = 20.

Verification: if you distribute the total 80 equally among 4 people, each gets 20. That’s the average (Omnicalculator).

Verification with known answer 20

To double-check, add 20 four times: 20+20+20+20 = 80. That equals the original sum, confirming 20 is the correct average.

The pattern: for any dataset, the average multiplied by the count equals the sum.

How to calculate average in Excel?

Using the AVERAGE function

Excel’s AVERAGE function does the sum-and-divide automatically. Syntax: =AVERAGE(number1, [number2], ...) where number1 is required and up to 255 additional arguments are allowed (Microsoft Support).

To use it, select a cell, type =AVERAGE(range), select the cells (e.g., B2:E2), and press Enter (W3Schools).

AVERAGE ignores empty cells, text, and logical values like TRUE/FALSE (Excel Easy).

Example: =AVERAGE(A1:A3) for cells containing 2, 3, 4 returns 3 (W3Schools).

Manual calculation alternative

If you prefer not to use the function, you can manually sum the range (e.g., =SUM(A1:A10)) and divide by the count (=COUNT(A1:A10)). That gives the same result.

For conditional averages, use AVERAGEIF or AVERAGEIFS. For example, =AVERAGEIF(A:A, "May", B:B) averages values in B where column A equals “May” (Ajelix).

To average the top 3 values in a range, use =AVERAGE(LARGE(range,{1,2,3})). For dataset {20,15,10,5,3}, this returns 15 (Excel Easy).

The implication: Excel’s AVERAGE function makes large-scale averaging efficient and accurate.

How to calculate average percentage?

Average of percentages

Treat percentages as numbers. If you have scores of 80%, 90%, and 70%, the sum is 240% and the count is 3, so the average is 240% ÷ 3 = 80% (Calculator.net).

Average percentage of marks example

For students: if a student scores 85%, 92%, and 78% in three subjects, the average percentage is (85+92+78) ÷ 3 = 255 ÷ 3 = 85%.

This method works as long as all percentages are based on the same total. If they’re weighted differently (e.g., final exam counts more), use a weighted average instead.

The implication: averaging percentages requires caution when weights vary.

What’s clear and what remains uncertain about calculating averages

Confirmed facts

• The average formula is sum divided by count (Microsoft Support).
• Excel’s AVERAGE function works for numerical data and ignores non-numeric cells (Excel Easy).
• Examples with simple datasets produce known averages (e.g., 1,2,3,4,5 average = 3) (Calculator.net).

What remains unclear

• Best practices for averaging percentages with different weights are not covered in most basic guides.
• Whether to use average or median depends on data distribution, and that distinction can be tricky for beginners.
• Calculating average of fractions with different denominators can be confusing for some users.

“To find the average of a set of numbers, simply add all the numbers together and divide by the number of numbers in the set.”

Calculator.net (mathematics tool site)

“For example, the average of 24, 55, 17, 87 and 100 is simply 283 divided by 5, which equals 56.6.”

Omnicalculator (calculator platform)

For anyone who works with numbers — students tracking grades, analysts reviewing data, or budget planners — the average is the fastest way to see the big picture from a collection of values. The formula is simple, the Excel function makes it instant, and the same logic applies whether you’re averaging test scores or monthly expenses. The implication for learners and professionals alike: master the average formula first, then explore median, mode, and weighted average when your data demands it.

Frequently asked questions

Related reading: How Many Weeks in a Year – Exact Math and Facts · 1.4 kg to lbs: Convert 1.4 Kilograms to Pounds (3.086 lb)