How to use ARRAYFORMULA in Google Sheets
One formula for a whole column
How ARRAYFORMULA works
ARRAYFORMULA runs one formula across whole ranges at once, so you don't copy it down every row. Sheets only.
Adds one to every unit count in one go.
What you’ll do
You’ll work out the revenue for every order with a single formula. Writing one formula for a whole column means nothing to copy down and nothing to forget.
Try it
Type =ARRAYFORMULA(E2:E11+1) into K2 and press Enter. Watch what the sheet does.
The result will appear in K2.
Shortcut: type =E2:E11+1 and press Ctrl+Shift+Enter Mac ⌘+Shift+Enter instead of Enter. Sheets wraps it in ARRAYFORMULA for you. (Wrap the formula in ARRAYFORMULA.)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Rep | Region | Product | Units | Price | Order date | Ship date | |||
| 2 | 1001 | Ana | West | Desk | 3 | 240 | 1/5/2026 | 1/9/2026 | |||
| 3 | 1002 | Bo | East | Chair | 8 | 85 | 1/12/2026 | 1/20/2026 | |||
| 4 | 1003 | Cy | West | Lamp | 12 | 30 | 1/19/2026 | 1/22/2026 | |||
| 5 | 1004 | Di | North | Desk | 2 | 240 | 2/2/2026 | 2/13/2026 | |||
| 6 | 1005 | Ana | West | Chair | 5 | 85 | 2/9/2026 | 2/12/2026 | |||
| 7 | 1006 | Eve | South | Shelf | 4 | 120 | 2/16/2026 | 2/27/2026 | |||
| 8 | 1007 | Bo | East | Lamp | 20 | 30 | 3/2/2026 | 3/4/2026 | |||
| 9 | 1008 | Cy | West | Shelf | 1 | 120 | 3/9/2026 | 3/18/2026 | |||
| 10 | 1009 | Di | North | Chair | 6 | 85 | 3/16/2026 | 3/19/2026 | |||
| 11 | 1010 | Eve | South | Desk | 7 | 240 | 3/23/2026 | 4/1/2026 |
Drill locked
Unlock the other 44 lessons for $49.99
You’ve seen how ARRAYFORMULA works. Pro lets you write it yourself on real data and get checked instantly, with practice sets and section reviews for every lesson.
In K2, work out the revenue (units times price) for every order with a single formula.
One payment, no subscription.