fx =AVERAGE(B1:B50)ABCJan Score8782.3Feb Score92Mar Score78
📈 Statistical

AVERAGE Formula for Statistical

Calculate the average of a range. Copy-paste ready for Excel, Google Sheets, and Airtable.

=AVERAGE(B1:B50)
When you need this: When you need to find the mean rating of 50 customer reviews (scores 1–5 in column B) to gauge product satisfaction.

How it works

  1. 1Select the range of numbers (B1:B50).
  2. 2The AVERAGE function sums all values and divides by count.
  3. 3Ignores empty cells and text automatically.

Variations

Average ignoring zeros
=AVERAGEIF(B1:B50,">0")
Average with multiple criteria
=AVERAGEIFS(B1:B50,A1:A50,"Active",C1:C50,">10")

Related Formulas

COUNTIF — Count cells that meet a conditionStatisticalCOUNTIFS — Count cells meeting multiple conditionsStatisticalMAX / MIN — Find the largest or smallest value in a rangeStatisticalAVERAGEIF — Average values meeting a conditionStatistical

Need a formula that's not here?

Generate custom formula →