how to calculate average on excel

Easily Calculate Average in Excel: Step-by-Step Guide

By Sarah Brown
AD

Ever found yourself staring at a column of figures in Excel, wondering how to find the average? You're not alone, and it's easier than you think. Let's dive into the world of averages and explore how to calculate them in Excel.

Whether you're a seasoned Excel user or just starting out, this guide will walk you through the simplest and most efficient ways to find the average of your data. So, let's roll up our sleeves and get started!

Calculating Averages with AVERAGE Function

The AVERAGE function is your go-to tool for finding averages in Excel. It's simple, versatile, and forms the backbone of this guide.

AD
How to Calculate the Class Average in Excel (6 Methods) - ExcelDemy
How to Calculate the Class Average in Excel (6 Methods) - ExcelDemy
Exponential Smoothing Method for Moving Average in Excel
Exponential Smoothing Method for Moving Average in Excel
How to Calculate the Class Average in Excel (6 Methods) - ExcelDemy
How to Calculate the Class Average in Excel (6 Methods) - ExcelDemy

But before we dive into all its functionalities, let's start with the basics: calculating the average of a range of cells.

Average of a Single Range

Assume you have a range of cells from A1 to A10 with your data. To find the average, simply type the following in a cell where you want the result:

How to Calculate the Class Average in Excel (6 Methods) - ExcelDemy
How to Calculate the Class Average in Excel (6 Methods) - ExcelDemy
How to Calculate Average Sales per Month in Excel (2 Easy Methods) - ExcelDemy
How to Calculate Average Sales per Month in Excel (2 Easy Methods) - ExcelDemy

=AVERAGE(A1:A10)

Hit Enter, and voila! Excel will compute and display the average of your numbers.

AD

Average of Multiple Ranges

Now, what if you want to find the average of data from different ranges? The AVERAGE function can handle that as well. Suppose you have data in the ranges A1:A5, B1:B5, and C1:C5. To find the average of all these, use:

=AVERAGE(A1:A5, B1:B5, C1:C5)

As simple as that, you've just calculated the average of numbers scattered across different ranges.

AD

Calculating Averages with Other Functions

While the AVERAGE function is great, there might be times when you need to calculate averages under specific conditions. Excel's other functions can help with that.

Let's explore two such scenarios:

Average of Non-blank Cells

Say you have a range of cells with some blank and non-blank cells, and you want to find the average of just the non-blank ones. The AGGREGATE function is perfect for this. Enter this formula:

AD

=AGGREGATE(1, 6, A1:A10)

The number 1 indicates that we want the average (MEAN), and 6 ignores errors like blank cells.

Average based on Criteria

Sometimes, you might want to find the average under specific conditions. The AVERAGEIF and AVERAGEIFS functions come in handy for that. For instance, let's say you want to find the average of numbers in column A where column B equals 'apple'. Use:

=AVERAGEIF(B2:B10, "apple", A2:A10)

And if you have multiple criteria, use the AVERAGEIFS function:

=AVERAGEIFS(A2:A10, B2:B10, "apple", C2:C10, "large")

This formula will give you the average of numbers in column A where both conditions are met: column B equals 'apple' and column C equals 'large'.

Average of Samples

Excel also allows you to find the average of a sample from a population using the AVERAGEA function. This function works with sample sizes ranging from 2 to 30. For a sample size of 3, the formula is:

=AVERAGEA(A1:A30)

Here, A1:A30 represents the population, and the first three cells contain the sample.

And there you have it! You're now well-equipped to calculate averages in Excel, from simple to complex scenarios. So go ahead, harness the power of these functions, and watch your data insights grow. Happy number crunching!

AD