fx =SUM(A1:A100)ABCQ1 Sales$42,500$170,000Q2 Sales$38,200Q3 Sales$51,800
📊 Math

SUM Formula for Math

Add up a range of numbers. Copy-paste ready for Excel, Google Sheets, and Airtable.

=SUM(A1:A100)
When you need this: When you need to total quarterly revenue figures (Q1-Q4 sales in cells A1:A4) for an annual report.

How it works

  1. 1Identify the range of cells containing numbers (A1:A100).
  2. 2The SUM function adds every value in that range instantly.
  3. 3Returns a single number—the total.

Variations

Sum with conditional total
=SUM(IF(B1:B100="Complete",A1:A100,0))
Sum multiple ranges
=SUM(A1:A10,C1:C10,E1:E10)

Related Formulas

SUMIF — Sum values that meet a single conditionMathSUMIFS — Sum values meeting multiple conditionsMathROUND — Round a number to specified decimal placesMathARRAYFORMULA — Apply a formula to an entire column (Google Sheets)Math

Need a formula that's not here?

Generate custom formula →