fx N/A (use Ctrl+Shift+Enter)ABCQ1 Sales$42,500$170,000Q2 Sales$38,200Q3 Sales$51,800
📊 Math

ARRAYFORMULA Formula for Math

Apply a formula to an entire column (Google Sheets). Copy-paste ready for Excel, Google Sheets, and Airtable.

=ARRAYFORMULA(A1:A100*B1:B100)
When you need this: When you want to multiply price (A1:A100) × quantity (B1:B100) automatically for all rows in Google Sheets.

How it works

  1. 1ARRAYFORMULA tells Google Sheets to apply a formula to every row in a range.
  2. 2Without it, you'd copy the formula down row by row.
  3. 3Perfect for auto-filling formulas when new data is added.

Variations

Array with IF condition
=ARRAYFORMULA(IF(A1:A100="","",(A1:A100*B1:B100)))
Array with SUM
=ARRAYFORMULA(IF(A1:A100<>"",A1:A100*B1:B100,""))

Related Formulas

SUM — Add up a range of numbersMathSUMIF — Sum values that meet a single conditionMathSUMIFS — Sum values meeting multiple conditionsMathROUND — Round a number to specified decimal placesMath

Need a formula that's not here?

Generate custom formula →