1
00:00:00,080 --> 00:00:04,238
A Google Sheet can have a correct line-total formula in old

2
00:00:04,238 --> 00:00:07,703
rows but an empty result when a new order appears.

3
00:00:07,703 --> 00:00:11,167
In our fictional order list, three rows total sixty dollars.

4
00:00:11,167 --> 00:00:15,325
A fourth order should add thirty-six dollars without dragging another formula.

5
00:00:15,325 --> 00:00:20,176
We will use one ARRAYFORMULA, append the new row, and verify ninety-six dollars.

6
00:00:20,776 --> 00:00:25,094
Download the CSV and import it into a new practice Google Sheet.

7
00:00:25,094 --> 00:00:29,413
Keep the headers in row one: Order ID, Quantity, and Unit price.

8
00:00:29,413 --> 00:00:31,932
Column D is reserved for Line total.

9
00:00:31,932 --> 00:00:36,969
The initial rows are two times twelve, three times seven, and one times fifteen.

10
00:00:36,969 --> 00:00:40,568
They should become twenty-four, twenty-one, and fifteen dollars.

11
00:00:40,568 --> 00:00:42,367
Use a private practice copy.

12
00:00:42,967 --> 00:00:47,221
In D two, enter equals ARRAYFORMULA open parenthesis IF open parenthesis

13
00:00:47,221 --> 00:00:51,475
B two colon B equals quote quote, comma quote quote, comma

14
00:00:51,475 --> 00:00:56,503
B two colon B times C two colon C close parenthesis close parenthesis.

15
00:00:56,503 --> 00:01:00,757
The exact copyable formula appears on screen and in the guide.

16
00:01:00,757 --> 00:01:05,011
It returns blank when Quantity is blank, then multiplies Quantity by

17
00:01:05,011 --> 00:01:06,945
Unit price for filled rows.

18
00:01:07,545 --> 00:01:10,674
An array formula needs room to display its results.

19
00:01:10,674 --> 00:01:14,499
Before entering it, clear any typed values or older formulas in

20
00:01:14,499 --> 00:01:18,323
D two downward, including a stray value in a future row.

21
00:01:18,323 --> 00:01:22,496
Do not delete the quantity or price inputs in B and C.

22
00:01:22,496 --> 00:01:26,321
If Google Sheets reports an array expansion error, check the first

23
00:01:26,321 --> 00:01:30,841
blocked cell in column D and remove only the unwanted output-cell content.

24
00:01:31,441 --> 00:01:35,966
After the formula expands, D two should show twenty-four, D three

25
00:01:35,966 --> 00:01:38,229
twenty-one, and D four fifteen.

26
00:01:38,229 --> 00:01:43,131
Add those values independently: twenty-four plus twenty-one plus fifteen equals sixty.

27
00:01:43,131 --> 00:01:47,279
If you see a single result or an error, verify the

28
00:01:47,279 --> 00:01:50,673
exact range letters and commas against the written guide.

29
00:01:50,673 --> 00:01:53,690
This example assumes a United States spreadsheet locale.

30
00:01:54,290 --> 00:01:58,060
In the next empty row, type A dash one oh four

31
00:01:58,060 --> 00:02:02,172
in A five, four in B five, and nine in C five.

32
00:02:02,172 --> 00:02:03,543
Leave D five untouched.

33
00:02:03,543 --> 00:02:07,655
The array formula in D two should calculate thirty-six there automatically.

34
00:02:07,655 --> 00:02:10,739
The four line totals now add to ninety-six.

35
00:02:10,739 --> 00:02:15,194
This is the decisive check that a new order uses the original formula.

36
00:02:15,794 --> 00:02:19,972
The download and answer check give you the input rows, exact

37
00:02:19,972 --> 00:02:23,390
D two formula, and ninety-six-dollar final sum.

38
00:02:23,390 --> 00:02:27,948
Google documents ARRAYFORMULA as a way to return values into multiple cells.

39
00:02:27,948 --> 00:02:30,606
It does not repair incorrect source numbers.

40
00:02:30,606 --> 00:02:34,784
If Quantity or Unit price is text, inspect those inputs separately.

41
00:02:34,784 --> 00:02:38,962
Keep column D free below the formula when adding future rows.