Average is a very useful mathematical operation. In order to find the average of a few numbers, we need to sum the input numbers and divide them by the number of inputs. We can easily calculate the average of input numbers in Excel using various methods. We can even calculate the average of inputs from different sheets of a workbook. In this article, we will show the methods to calculate the average from different sheets in Excel.

## How to Calculate Average from Different Sheets in Excel: 3 Methods

We can calculate the average from different sheets in Excel. In this article, we will discuss 3 simple methods to calculate the average from different sheets. Suppose we have 3 sheets containing data on sales of different shoes. We want to calculate the average. The sheets for our inputs are given below.

Sheet *Jan* (*January*).

Sheet *Feb* (*February*).

Sheet *Mar* (*March*).

### Method 1: **Calculating **Average of Same Range of Cells from Different Sheets

In this method, we will use **the AVERAGE function** to calculate the average from different sheets.

#### 1.1. Average of a Single Cell from Different Sheets

Here we will show the steps to average a single cell from each sheet.

- At first, we have to select the cell where we want to put the average of inputs from different sheets. In our case, the cell is
**C6**of sheet*Method 1*where we will calculate the average of cell**C6**of sheets*Jan, Feb*, and*Mar*.

- We have to enter the cell and write the following formula.

`=AVERAGE(Jan:Mar!C6)`

Here, **Jan:Mar! **is the sheet range and **C6 **is the cells for input.

- We need to press the
**ENTER**key and use the**Fill Handle**to copy the formula to the cells below for other averages.

We can see the results in the cells.

#### 1.2. Average of Multiple Cells from Different Sheets

Here we will show the steps to average multiple cells from multiple sheets

- We have selected cell
**C11**to see the average.

- Input the following formula into the cell.

`=AVERAGE(Jan:Mar!C6:C9)`

Here, **Jan:Mar! **is the range of sheets and** C6:C9 **is the range of cells from the three input sheets.

- We need to press the
**ENTER**key.

We can see the result in the cell which is the average from the selected range of multiple selected sheets.

**Read More: **How to Calculate Average of Multiple Ranges in ExcelÂ

### Method 2: Calculating Average of Different Ranges of Cells from Different Sheets

Sometimes we may need to find the average of cells from different ranges of different sheets. In that case, we canâ€™t use the sheet range in the **AVERAGE** function.

- We have to select the cell where we want to get the average.

- We have to write the following formula in the cell.

`=AVERAGE(Jan!C6:C7,Feb!C8:C9,Mar!C7:C8)`

Here, **Jan!C6:C7 **is the sheet with a specific range for input. The same thing goes with the other two parts of the formula.

- We need to press the
**ENTER**key.

We can see the average of different ranges from different sheets here.

**Read More: **How to Average Filtered Data in Excel

### Method 3:Â **SUM **and **COUNT **Functions toÂ Calculate Average from Different Sheets

Instead of using the **AVERAGE **function, we can combine the **SUM** and **COUNT** functions to do the same task. We will show two different types of averages here.

#### 3.1. Average of a Single Cell from Different Sheets

Firstly, we will show the steps to calculate the average of a single selected cell from different sheets.

- Select cell
**C6**to see the result.

- We have to enter the cell and write the following formula in it.

`=SUM(Jan:Mar!C6)/COUNT(Jan:Mar!C6)`

Here, **Jan:Mar!C6 **is the sheet range with a specific cell. We use the mathematical operator division (**\**) in the formula.

- We need to press the
**ENTER**key and use**AutoFill**to copy the formula to the cells below.

We can see the average in each cell.

**Read More: **How to Do Subtotal Average in Excel

#### 3.2. Average of Multiple Cells from Different Sheets

We can also calculate the average of multiple cells from different sheets using the **SUM **and **COUNT **functions. We will show the steps to do that below.

- We have selected cell
**C11**.

- We need to enter the cell and write the following formula there.

`=SUM(Jan:Mar!C6:C9)/COUNT(Jan:Mar!C6:C9)`

Here, **Jan:Mar!C6:C9 **is the sheet range with a specific cell range for the inputs.

- We need to press the
**ENTER**key.

We can see the average in the cell.

**Read More:** How to Calculate Sum & Average with Excel Formula

**Download Practice Workbook**

You can download the practice workbook from here.

## Conclusion

Average is a very basic mathematical operation that helps with data analysis. In Excel, we can calculate the average from a cell or multiple cells of different sheets. We can choose the input range as we need. In this article, we have shown 3 such simple methods to calculate the average from different sheets. Hope it will be helpful to you. If you have faced any problems with the methods or if you have any suggestions, please let us know by comment.

## Related Articles

- How to Calculate Average of Text in Excel
- How to Calculate Average of Top 5 Values in Excel
- How to Average Negative and Positive Numbers in Excel
- How to Calculate Average Excluding Outliers in Excel
- How to Calculate Average and Standard Deviation in Excel
- How to Calculate Average Deviation in Excel Formula