1
00:00:00,080 --> 00:00:03,113
A three-month Excel total turns into #REF!

2
00:00:03,113 --> 00:00:05,388
after someone deletes the February column.

3
00:00:05,388 --> 00:00:09,559
In our fictional copy, the original values are forty, fifty and

4
00:00:09,559 --> 00:00:12,971
sixty, so the total must be one hundred fifty.

5
00:00:12,971 --> 00:00:17,142
We will reproduce the error, immediately Undo the deletion, and verify

6
00:00:17,142 --> 00:00:20,934
both the missing month and the total. Editing away #REF!

7
00:00:20,934 --> 00:00:24,346
without restoring the data would give a misleading answer.

8
00:00:24,946 --> 00:00:30,336
Open the fictional CSV in Excel and save it as a workbook copy.

9
00:00:30,336 --> 00:00:36,140
The one row contains forty January kits, fifty February kits, and sixty March kits.

10
00:00:36,140 --> 00:00:41,945
Enter =SUM(B2,C2,D2) in E2 and confirm the total is one hundred

11
00:00:41,945 --> 00:00:43,603
fifty before changing anything.

12
00:00:44,203 --> 00:00:48,395
In the disposable copy only, delete the entire February column C.

13
00:00:48,395 --> 00:00:52,588
Excel shifts March and the total left, and the explicit reference

14
00:00:52,588 --> 00:00:56,017
to deleted C2 can become #REF! in the formula.

15
00:00:56,017 --> 00:01:00,210
Select the error cell and read the formula bar so you

16
00:01:00,210 --> 00:01:01,734
know which reference broke.

17
00:01:02,334 --> 00:01:08,211
Press Control and Z once, or use Excel's Undo control, before making unrelated edits.

18
00:01:08,211 --> 00:01:11,737
The February column and its fifty kits should return.

19
00:01:11,737 --> 00:01:16,047
Select the total cell again; the original three-month formula should

20
00:01:16,047 --> 00:01:18,006
evaluate to one hundred fifty.

21
00:01:18,006 --> 00:01:21,924
This is the safest recovery when the deletion just happened.

22
00:01:22,524 --> 00:01:24,050
You could remove #REF!

23
00:01:24,050 --> 00:01:27,483
from the formula and add only the remaining months.

24
00:01:27,483 --> 00:01:32,441
That would produce one hundred, but fifty February kits would still be missing.

25
00:01:32,441 --> 00:01:36,637
A continuous range formula can sometimes avoid a broken reference when

26
00:01:36,637 --> 00:01:41,596
an interior column is deleted, yet it cannot bring the deleted values back.

27
00:01:42,196 --> 00:01:44,104
Stop editing the only copy.

28
00:01:44,104 --> 00:01:48,303
Compare with the original CSV, a version history entry, or a

29
00:01:48,303 --> 00:01:51,357
backup and recover the missing source column first.

30
00:01:51,357 --> 00:01:54,792
Then recheck the formula and all three month values.

31
00:01:54,792 --> 00:01:58,990
Do not invent a February value from the current total or

32
00:01:58,990 --> 00:02:00,517
promise an automatic fix.

33
00:02:01,117 --> 00:02:05,101
Compare your own practice copy with the answer check.

34
00:02:05,101 --> 00:02:07,757
The untouched sample total is 150.

35
00:02:07,757 --> 00:02:12,627
In a workbook copy, =SUM(B2,C2,D2) becomes a #REF!

36
00:02:12,627 --> 00:02:15,283
formula after deleting February column C.

37
00:02:15,283 --> 00:02:19,709
Immediate Undo restores the February 50 and the 150 total.

38
00:02:19,709 --> 00:02:24,579
Rewriting the formula without restoring the month would yield only 100,

39
00:02:24,579 --> 00:02:27,235
which is not the intended recovery.

40
00:02:27,235 --> 00:02:32,104
If the result differs, revisit the source data and the specific

41
00:02:32,104 --> 00:02:34,760
step rather than hiding the symptom.

42
00:02:34,760 --> 00:02:39,629
The matching written guide includes the exercise and primary product references.