FormulaCraft

SUM

SUM totals every number in one or more ranges, ignoring blank and text cells. It is the workhorse of any spreadsheet.

Excel
=SUM(B2:B100)
Google Sheets
=SUM(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 to add up.
  2. 2Blank cells and text are ignored.
  3. 3Add more ranges separated by commas, e.g. =SUM(B2:B100, D2:D100).

Need a version for your data?

Try: “Add up all the numbers 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: