ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
CateDateAmntCostTotal
2
Transport10 May 202210220
3
Vegies11 May 202210220
4
Fruits12 May 202210220
5
Drinks13 May 202210220
6
Meat14 May 202210220
7
Cutlery15 May 202220240
8
Cutlery One15 May 202220240
9
Cutlery40
10
11
12
CateTotal
13
Transport20
14
Food80140
15
16
CateAmount
17
Transport10
18
Other80100
19
20
I want to exclude A2 and A7 from the total. So I put the string inside. But it's not working.
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100