ARRAYFORMULA Function
Applies a formula to an entire range from a single cell in Google Sheets. Eliminates the need to copy formulas down a column — one formula handles the whole range.
Google Sheets
Syntax
ARRAYFORMULA(array_formula)Parameter
| Parameter | Beschreibung |
|---|---|
| array_formula | The formula to apply across the range. Use range references instead of single cells. |
Beispiele
Calculate total for every row at once
=ARRAYFORMULA(B2:B*C2:C)Ergebnis: Multiplies every row's B and C values, filling the entire column
Conditional labels for all rows
=ARRAYFORMULA(IF(B2:B>100, "High", "Low"))Ergebnis: Labels every row as High or Low based on column B
Add a prefix to every cell in a column
=ARRAYFORMULA("ID-" & A2:A)Ergebnis: Prepends 'ID-' to every value in column A
Tipps und Best Practices
- •ARRAYFORMULA is Google Sheets only — Excel uses Ctrl+Shift+Enter or dynamic arrays.
- •Use open-ended ranges (A2:A instead of A2:A100) to auto-include new rows.
- •Wrap with IF to avoid applying to empty rows: =ARRAYFORMULA(IF(A2:A<>"", formula, "")).
- •Only one ARRAYFORMULA is needed per column — don't copy it to other cells.
Verwandte Formeln
Brauchen Sie eine andere Formel?
Beschreiben Sie, was Sie brauchen, in einfachem Text und unsere KI generiert die Formel für Sie.
Formelgenerator ausprobieren