Formula guide · Google Sheets · Updated May 13, 2026
ARRAYFORMULA for an Entire Column
Use ARRAYFORMULA in Google Sheets to fill a formula down a whole column automatically.
Quick Answer
Wrap the row formula in ARRAYFORMULA and include a blank-row check so empty rows stay empty.
Copyable Formula
=ARRAYFORMULA(IF(A2:A="","",A2:A*B2:B))Syntax
=ARRAYFORMULA(IF(A2:A="","",formula_for_each_row))Google Sheets
Worked Example
| A | B | C |
|---|---|---|
| Qty | Price | Total |
| 2 | 15 | 30 |
| 3 | 20 | 60 |
Result: Calculates Total for every row where Qty is not blank.
Steps
- Write the formula for one row first.
- Replace single-cell references with full column ranges.
- Wrap the logic in ARRAYFORMULA.
- Add an IF blank check to avoid filling empty rows with zeroes.
Common Mistakes
- Forgetting the blank-row check.
- Using functions that do not expand cleanly inside ARRAYFORMULA.
- Applying full-column formulas to very large sheets without considering speed.
Excel vs Google Sheets Notes
This page is focused on Google Sheets. Excel may require a different function, pivot table, or Power Query workflow.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.