FormulaCraft

AVERAGE

AVERAGE adds the numbers in a range and divides by how many there are. Empty cells are skipped rather than counted as zero.

Excel
=AVERAGE(B2:B100)
Google Sheets
=AVERAGE(B2:B100)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1B2:B100 is the range.
  2. 2Only numeric cells are counted.
  3. 3Empty cells are skipped, not treated as zero.

Need a version for your data?

Try: “Average the values in column B”

Related

SUMIFSUMIFSCOUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: