We can use the **AVERAGE function** to **calculate the mean** of numbers in a **range**. The **AVERAGE Function **can treat up to 255 different arguments. These arguments include **numbers**, **cell references,** **ranges, arrays,** and **constants. **The steps below will walk through the process.

*Figure 1- Final result of the AVERAGE function*

**Syntax**

**=AVERAGE (number1, [number2], ...)**

**number1**: This is a number or cell reference that refers to numeric values**number2**[optional]: This is a number or cell reference that refers to numeric values

**Formula**

**=AVERAGE(C5:E5)**

**Setting up the Data**

- The
**Branches**of a store will be entered into**Column B** **Column C, D, and E**will contain the**Sales**for each of the stores for 3 days- The
**mean or average sales**for each branch will be returned in**Column F**

* Figure 2 – Setting up the Data*

**Calculate Mean Sales for each Branch**

- We will click on
**Cell F5** - We will insert the formula below into
**Cell F5**

**=AVERAGE(C5:E5)** - We will press the
**enter**key

* Figure 3- Mean Sales for Vegas*

- We will click on
**Cell F5**again - We will
**double click**on the fill handle tool which is the small plus sign you see at the bottom right of**Cell F5.**Select and drag down to copy the formula to other cells.

*Figure 4- Mean Sales for Stores*

**Note**

- Any empty cell within the range is ignored by the
**AVERAGE Function** - The
**AVERAGE FUNCTION**sums the**numbers in the range**and divides the sum by the total number of numbers

**Instant Connection to an Expert through our Excelchat Service**

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

## Leave a Comment