## How to Calculate Average in Excel

- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS

### Excel AVERAGE Function

**=AVERAGE(number1, [number2], …)**or

**AVERAGE(cell references or cell range)**

**=AVERAGE(D2:D11)**then press

**Enter**key. It will return $1,385 in the cell.

**NOTE:**

- When using the AVERAGE function, cells containing zero values are counted, while blank cells are not counted.
- Also, cells containing text string and boolean values are neglected. But if you type boolean values directly into the AVERAGE, they are counted. The boolean value - TRUE is equal to 1, while the boolean value - False is equal to 0. Example, the formula
**=AVERAGE(TRUE, FALSE)**will returns 0.5. This is the average of 1 and 0.

**See:**

### Excel AVERAGEA Funtion

**=AVERAGEA(value1, [value2], …)**

**value1**,

**value2**, … are values, arrays, cell references or ranges that you want to calculate the average. The first argument is required, while the other (up to 255) arguments are optional.

**AVERAGEA**formula, the following should be noted:

- Empty cells are ignored.
- Text values returned by other formulas, including empty string are evaluated as 0.
- Boolean value TRUE is evaluated as 1, while boolean value FALSE is evaluated as 0.

**=AVERAGEA(5,FALSE)**returns 2.5, which is the average of 5 and 0. The formula

**=AVERAGEA(5,TRUE)**returns 3, which is the average of 5 and 1.

**NOTE:**

### Excel AVERAGEIF Function

**AVERAGEIF(range, criteria, [average_range])**then press

**Enter**key.

**Where:**

**Range**is the range of cells where the given criteria will be tested.**Criteria**is the condition used to determine which cells to include when calculating the average. The criteria can be supplied in the form of a number, logical expression, text value, or cell reference. For example, 2, ">2", "cat", or B2.**Average_range**(Optional) is the cells you actually want to calculate their average. If omitted, Excel will calculate an average of the values in the**range**argument.

**=AVERAGEIF(B2:B11, "male", D2:D11)**then press

**Enter**key.

**$1,440**.

### AVERAGEIFS

**AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)**

**Where:**

**Average_range**is the range of cells that you want to average.**Criteria_range1, criteria_range2, …**are the ranges where the specified criteria will be tested. It accepts up 127 arguments. Criteria_range1 is required, while the subsequent ones are optional.**Criteria1, criteria2, …**are the criteria that tells Excel which cells to include when calculating the average. You can supply the criteria in the form of a number, logical expression, text value, or cell reference. Criteria1 is required, subsequent criteria are optional.

**=AVERAGEIFS(D2:D11, B2:B11, "female", C2:C11, "married")**then press the

**Enter**key.

**$1,600**.

**Check:**

## How to Calculate Median in Excel

**3**.

**3.5**

**=MEDIAN(number1, [number2], …)**then press the

**Enter**key.

**Where:**

**Number1, number2, …**are numeric values you wish to find their median and can be up to 225 arguments. These can be numbers, dates, named ranges, arrays, or references to cells containing numbers. Number1 is required, while the subsequent numbers are optional.

**The following are worth noting for Excel median calculation:**

- Cells with zero value are included in calculation.
- Empty cells and cells containing text and boolean values are not included in calculation.
- If you type the boolean values directly as arguments in the MEDIAN function, they are counted. The boolean TRUE value is evaluated as 1, while the boolean FALSE value is evaluated as 0. For example, the formula
**=MEDIAN(TRUE,FALSE,5,6,7)**returns 5, which is the median of the numbers {1, 0, 5, 6, 7}.

**=MEDIAN(D2:D11)**then press the

**Enter**key.

**$1,350**.

**To confirm the answer**, you can

**sort the data**in the cells which you wish to find their median either in ascending or descending order. Since number of our data set was even (10), Excel returned the average of the 5th and 6th data (i.e. $1,300 and $1,400) which is equal to $1,350.

**See:**

## How to Calculate Mode in Excel

**4**.

**=MODE(range)**or

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

**then press**

**Enter**key.

**Where:**

**Range**or**number1, [number2], ...**is the range of cells or data set you wish to find their mode.

**=MODE(D2:D11)**then press the Enter key.

**#N/A**

**error**because all the values in the cell range occurred only once. So there is no mode.

**NOTE:**

### Conclusion

**Here**to subscribe to our blog via email so that we will update you when new WordPress themes are released by these sites.

## No comments:

## Post a Comment

WHAT'S ON YOUR MIND?

WE LOVE TO HEAR FROM YOU!