Question EN

How do I calculate an average in Excel?

Answer

The AVERAGE function calculates the arithmetic mean. For example, =AVERAGE(A1:A10) computes the average of a 10-cell range.

Detailed explanation

For calculating averages in Excel, use the AVERAGE function.

Basic Usage

=AVERAGE(A1:A10)

Calculates the arithmetic mean of all numbers in the range A1:A10.

Multiple Ranges

You can specify multiple ranges separated by commas:

=AVERAGE(A1:A10, C1:C10, E5)

Conditional Average

If you need the average only for values meeting a criterion:

=AVERAGEIF(B2:B100, ">0")

Calculates the average of only positive numbers.

What Gets Ignored

AVERAGE automatically skips:

Empty cells
Text
Logical values (TRUE/FALSE)

But cells containing zero are included!

07.01.2026 Excel / Google Sheets

Need a custom formula?

Describe your task — AI will generate a working formula in seconds

Generate Formula

Related Questions

How do I calculate a percentage in Excel?

Multiply the number by the percentage and divide by 100. For example, =A1*15/100 or simply =A1*15% — Excel understands both.

How do I round numbers in Excel?

Use the ROUND function: ROUND(number, decimals). For example, =ROUND(3.14159, 2) returns 3.14. For rounding up use ROUNDUP, for down use ROUNDDOWN.

How do I raise a number to a power in Excel?

Use the ^ operator or the POWER function. For example, =2^3 or =POWER(2,3) — both return 8 (two cubed).

How do I get the absolute value in Excel?

The ABS function returns the absolute value of a number. For example, =ABS(-15) returns 15, and =ABS(15) also returns 15.

How do I combine text from multiple cells in Excel?

Use the & operator or the CONCATENATE function. For example, =A1&" "&B1 joins cell contents with a space between them.

Great formula!

Sign in to save formulas and get more free requests

Sign in for free