Members lesson 16
ARRAYFORMULA
Fill a whole result column with one formula and leave unused rows blank.
What you will practice
- Fill a result column with one ARRAYFORMULA
- Run IF across a range
- Keep unused rows blank
Lesson preview
Starting tableOrder lines
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Product | Qty | Price | Total | Size | Blank-safe total | Summary | |||
| 2 | Pens | 2 | 12 | |||||||
| 3 | Folders | 5 | 5 | |||||||
| 4 | Markers | 3 | 10 | |||||||
| 5 | Tape | 4 | 4 |