AVERAGE

Beginner

Statistical

Calculates the arithmetic mean of numbers in a range. Ignores text and logical values.

Syntax
=AVERAGE(number1, [number2], ...)
Parameters
number1
Required
(number | range)

First number or range to average

number2(number | range)

Additional numbers or ranges (optional)

Examples
Real-world examples to help you understand how to use AVERAGE

Average test scores

=AVERAGE(A1:A10)

Calculates mean of all scores

Result: Average score

Average with condition

=AVERAGEIF(A1:A10, ">0")

Average only positive numbers

Result: Average of positive values

Weighted average

=SUMPRODUCT(A1:A5, B1:B5) / SUM(B1:B5)

Weighted average using prices and quantities

Result: Weighted mean

Common Use Cases
  • ✓Calculate average sales
  • ✓Find mean test scores
  • ✓Compute average temperatures
  • ✓Track average response times
  • ✓Analyze performance metrics
Pro Tips
  • 💡AVERAGE ignores empty cells and text
  • 💡Use AVERAGEIF for conditional averages
  • 💡Consider MEDIAN for skewed data
  • 💡Combine with ROUND for cleaner results
Common Errors
  • ⚠️Including text values (they're ignored)
  • ⚠️Division by zero if all cells are empty
  • ⚠️Not handling outliers
Related Formulas
AVERAGEIFAVERAGEIFSMEDIANMODE

Need a Custom AVERAGE Formula?

Our AI can generate tailored formulas based on your specific needs

Generate Custom Formula