# ARRAYFORMULA formula generator

> Describe what you need and get a ARRAYFORMULA formula for Google Sheets, run on real data before you copy it. Plus 8 tested ARRAYFORMULA examples.

Source: https://spreadsheetpractice.com/tools/formula-generator/arrayformula · Updated October 29, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

ARRAYFORMULA lets one formula work on whole ranges instead of single cells.

Describe the task at [ARRAYFORMULA formula generator](https://spreadsheetpractice.com/tools/formula-generator/arrayformula) and get a ARRAYFORMULA formula for Google Sheets, tested on real data.

## Tested ARRAYFORMULA examples

### Why does Excel add @ to my formula

`=B2:B7*C2:C7`

Excel. Result on the sample sheet: 6 rows (D2:D7). [See it and try it](https://spreadsheetpractice.com/formulas/excel-adds-at-sign-to-formula)

### Make a multiplication table

`=A3:A12*B2:K2`

Excel. Result on the sample sheet: 10 rows (B3:K12). [See it and try it](https://spreadsheetpractice.com/formulas/make-a-multiplication-table)

### Sum each row with one formula

`=B2:B6+C2:C6+D2:D6`

Excel. Result on the sample sheet: 5 rows (E2:E6). [See it and try it](https://spreadsheetpractice.com/formulas/sum-each-row-with-one-formula)

### Apply a formula to an entire column

`=ARRAYFORMULA(IF(A2:A="","",B2:B*C2:C))`

Google Sheets. Result on the sample sheet: 46 rows (D2:D47). [See it and try it](https://spreadsheetpractice.com/formulas/apply-a-formula-to-an-entire-column)

### Calculate days between dates for a whole column

`=ARRAYFORMULA(IF(C2:C8="","",C2:C8-B2:B8))`

Google Sheets. Result on the sample sheet: 7 rows (D2:D8). [See it and try it](https://spreadsheetpractice.com/formulas/days-between-dates-for-a-whole-column-in-google-sheets)

### Use IF with ARRAYFORMULA

`=ARRAYFORMULA(IF(B2:B9="","",IF(B2:B9>=F1,"Pass","Fail")))`

Google Sheets. Result on the sample sheet: 8 rows (C2:C9). [See it and try it](https://spreadsheetpractice.com/formulas/if-with-arrayformula)

### Create a list of the first day of each month

`=EDATE(B1,SEQUENCE(B2,1,0))`

Excel. Result on the sample sheet: 12 rows (D2:D13). [See it and try it](https://spreadsheetpractice.com/formulas/list-the-first-day-of-each-month)

### Create a list of working days

`=WORKDAY(B1-1,SEQUENCE(B2),B3:B4)`

Excel. Result on the sample sheet: 8 rows (D2:D9). [See it and try it](https://spreadsheetpractice.com/formulas/list-working-days)

## Questions

### What does the ARRAYFORMULA formula generator do?

You describe the task in plain English, and it writes the formula, using ARRAYFORMULA where that's the right tool, for your table or a sample one. The formula is run in our engine in Google Sheets mode before you see it, so you get its result, not just a guess.

### What does ARRAYFORMULA do?

ARRAYFORMULA lets one formula work on whole ranges instead of single cells.

### Can I learn to write ARRAYFORMULA formulas myself?

Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the ARRAYFORMULA function page has a practice exercise.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
