Formula guide · Google Sheets · Updated May 13, 2026
ARRAYFORMULA Not Working in Google Sheets
Fix ARRAYFORMULA issues caused by incompatible functions, missing blank checks, or mismatched ranges.
Quick Answer
ARRAYFORMULA usually fails when the inner formula is not array-friendly or when the ranges have different sizes.
Copyable Formula
=ARRAYFORMULA(IF(A2:A="","",A2:A*B2:B))Syntax
=ARRAYFORMULA(IF(A2:A="","",formula))Google Sheets
Worked Example
| Symptom | Likely fix |
|---|---|
| Only first row works | Use full column ranges |
| Extra zeros | Add blank-row check |
| Error | Check range sizes |
Result: A compatible formula with aligned ranges fills the column automatically.
Steps
- Confirm the one-row formula works first.
- Replace single cells with matching column ranges.
- Add a blank-row check.
- Check whether the function supports array expansion.
Common Mistakes
- Using mixed range sizes inside the same ARRAYFORMULA.
- Forgetting to keep empty rows empty.
- Expecting every Google Sheets function to be array-friendly.
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.