Arrays & ARRAYFORMULA › ARRAYFORMULA40 / 67

Progress is saved on this device. Sign in or sign up free to keep it in your account.

MediumFreeARRAYFORMULA

ARRAYFORMULA: subtotal every row at once

Catering orders arrive from a Google Form into this sheet. Because new rows keep coming, the admin does not want to copy the subtotal formula into every row by hand.

Task

In D2, write one ARRAYFORMULA formula that calculates the subtotal (portions × price) for rows 2 to 5 at once.

Cells to fillD2:D5

Required functionsARRAYFORMULA

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
Inside ARRAYFORMULA, operations on ranges are calculated row by row.
Hint 2
Multiply two ranges of the same length: B2:B5*C2:C5.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

D2

=ARRAYFORMULA(B2:B5*C2:C5)

Explanation

=ARRAYFORMULA(B2:B5*C2:C5) returns four numbers at once that fill D2:D5. Both ranges must be the same length. In real Sheets, an open range like B2:B makes new rows from the Form get calculated automatically.

Starting worksheet: Sheet1
Row	A	B	C	D
1	Menu	Portions	Price	Subtotal
2	Chicken rice box	40	28,000
3	Snack box	60	15,000
4	Mini tumpeng	12	45,000
5	Iced tea	100	5,000
6
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result