ARRAYFORMULA practice

ARRAYFORMULA applies a formula to a whole range at once instead of one cell at a time, in Google Sheets. Below are the 3 Google Sheets exercises on Sheetsdrill that use it, each checked instantly in your browser.

Syntax

ARRAYFORMULA(array_formula)

What people get wrong

Wrap the entire expression, not just one argument, and make sure every range in it has the same height.

Google Sheets exercises that use ARRAYFORMULA

• Revenue with ARRAYFORMULALevel 4Pro
• Codes that are too longLevel 4Pro
• Valid order IDsLevel 5Pro

Often used together with: IF, LEN, REGEXMATCH, SUM