Calculate the average of a group of numbers

To calculate the average of a group of numbers in Excel, use the AVERAGE function.

✅ Basic Syntax

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

📌 Examples

Example 1: Average of a range

If your numbers are in cells A1 to A5, use:

=AVERAGE(A1:A5)

Example 2: Average of specific numbers

=AVERAGE(10, 20, 30, 40)

Example 3: Multiple ranges

=AVERAGE(A1:A5, B1:B5)

⚠️ Things to Know

• It ignores blank cells and text values automatically.
• To include only non-zero numbers, use:

=AVERAGEIF(A1:A5, "<>0")

• To ignore errors in the range, use:

=AVERAGEIF(A1:A5, "<>#N/A")

Or better:

=AVERAGEIF(A1:A5, ">=0")   ' if only positive numbers are valid