How to Find Average: Step-by-Step Guide and Examples

Most people reach for a calculator the moment they need an average, but the logic underneath is simpler than it looks. Whether you’re a student averaging test scores, a manager checking quarterly sales, or just someone trying to figure out their average commute time, the same handful of formulas does the heavy lifting. Below is a straightforward guide that walks through the arithmetic mean, shows how to calculate it in Excel, and covers the practical variations you’ll actually need—backed by step-by-step examples and real formulas.

Basic Formula: Sum of numbers ÷ count · Example: 10, 20, 30, 40, 50 = 30 · Excel Method: =AVERAGE(range) · Twinkl Types: Mean, median, mode · BYJU’S Definition: Arithmetic mean

The key facts table below summarizes the core formula and examples used throughout this guide.

How can I calculate an average?

Basic steps to add and divide

The arithmetic mean follows a two-step process: add all the numbers together, then divide by how many numbers you have. For the sequence 10, 20, 30, 40, 50, you would first sum to 150, then divide by 5 to get 30.

According to Microsoft Support (official documentation), this same principle applies whether you’re averaging temperatures, prices, or a handful of test scores. The formula stays consistent: total sum divided by the count of values.

Using the arithmetic mean formula

The formula reads as: Average = (Sum of all values) ÷ (Number of values). W3Schools, a widely referenced programming tutorial site, notes that Excel’s AVERAGE function implements exactly this logic under the hood.

For example, =AVERAGE(2,3,4) returns 3. That’s because (2+3+4) ÷ 3 = 9 ÷ 3 = 3.

What is the average formula?

Arithmetic mean equation

The standard average formula is: Average = Sum ÷ Count. This applies universally across math, statistics, and everyday calculations.

Twinkl, an educational resource platform, defines the mean as “calculated by adding all numbers then dividing by the count of items.” BYJU’S, another major math education site, refers to this same concept as the “arithmetic mean”—the most commonly used type of average.

Examples from Twinkl and BYJU’S

Consider finding the average of 50 and 100. The sum is 150, and dividing by 2 values gives you 75. The same logic scales to any dataset size.

For the numbers 10, 20, 30, 40, 50: the sum is 150, and with 5 items, the average equals 30.

How to calculate average percentage?

Percentage of marks method

Calculating an average percentage follows the same steps as any other average. You sum the percentages and divide by the number of entries.

Coefficient, a business operations platform, recommends entering your data as percentages, then applying the AVERAGE function. Format the result as a percentage, and Excel handles the display.

Step-by-step for scores

Imagine a student has test scores of 85%, 90%, and 78%. The sum is 253%, divided by 3 gives approximately 84.3%.

For weighted averages—like when assignments are worth different percentages—use the formula: =SUMPRODUCT(percentage_range, weight_range)/SUM(weight_range). Coefficient provides this exact formula for scenarios where simple averaging doesn’t reflect true performance.

How to find average in Excel?

AVERAGE function basics

In Excel, the AVERAGE function calculates the arithmetic mean for you. Type =AVERAGE( and select your range, then close the parentheses and press Enter.

Per W3Schools (Excel tutorial reference), the syntax is =AVERAGE(number1, [number2], …). Excel ignores text, empty cells, and logical values during calculation.

Handling ranges

To average values in cells A1 through A10, you would write =AVERAGE(A1:A10). For non-contiguous ranges, use commas: =AVERAGE(A1:A5, B1:B5).

GoSkills, a professional skills platform, explains that AVERAGEIF lets you average only cells meeting a condition: =AVERAGEIF(range, criteria, [average_range]). This is useful for averaging only scores above a certain threshold.

When working across sheets, reference multiple ranges like =AVERAGE(Sheet1!A1:A10, Sheet2!A1:A10). Coefficient notes this works cleanly for combining data from different worksheets.

The implication: mastering AVERAGEIF and AVERAGEIFS lets you handle conditional averaging without array formulas, which Microsoft’s official performance guide confirms are significantly slower to calculate.

How to find average speed?

Total distance over total time

Average speed isn’t a simple arithmetic mean when speeds vary. Instead, you divide total distance by total time.

According to Excel tutorials on YouTube, the formula is: =distance/(time*24). You multiply time by 24 because Excel stores time as a fraction of a day—so one hour becomes 1/24.

Real-world examples

If you traveled 120 miles in 2 hours, average speed is 120 ÷ 2 = 60 mph. In Excel, with distance in A2 and time in B2 (formatted as HH:MM:SS), you would use =A2/(B2*24).

Microsoft Learn’s performance documentation notes that Excel 2016 and later versions handle these calculations more efficiently, particularly when working with large datasets.

The catch: regional settings can affect how Excel interprets time entries, so always verify your time format matches the formula expectations.

“Since average speed is just Distance/Time, you would think it should be easy to get Microsoft Excel to calculate it.”

— Excel Tutor on YouTube (tutorial on average speed formulas)

“You should always use the SUMIFS, COUNTIFS, and AVERAGEIFS functions instead of array formulas where you can because they are much faster to calculate.”

— Microsoft Official Documentation (Excel Performance Guide)

The mean formula is one of those tools that rewards knowing it well—once you internalize Sum ÷ Count, you can adapt it for percentages, weighted averages, and even speed calculations. For students managing grades, the straightforward approach works fine. For professionals working with weighted data, the SUMPRODUCT formula adds precision. And for anyone calculating travel times, the distance-over-time approach in Excel prevents the most common mistakes.

For spreadsheet users, the practical takeaway is clear: master AVERAGE first, then move to AVERAGEIF and AVERAGEIFS when you need conditional logic. Those functions are faster, easier to audit, and built directly into Excel rather than requiring array formula workarounds.