ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
日期分類項目金額
2
2023/1/28交通ICOCA1000條件平均
3
2023/1/28餐飲章魚燒600= 10001000
=AVERAGEIF(D2:D20,1000)
4
2023/1/28餐飲大阪燒3806> 5003884.277778
=AVERAGEIF(D2:D20,">500")
5
2023/1/29餐飲烏龍麵2250<1000610
=AVERAGEIF(D2:D20,"<1000")
6
2023/1/29交通ICOCA1000>〔D5〕7233.375
=AVERAGEIF(D2:D20,">"&D5)
7
2023/1/29餐飲漢堡排3366餐飲2157.545455
=AVERAGEIF(B2:B20,F7,D2:D20)
8
2023/1/29購物MUJI5510烏龍麵2325
=AVERAGEIF(C2:C20,"烏龍麵",D2:D20)
9
2023/1/29購物藥妝33605*麵1907.5
=AVERAGEIF(C2:C20,"*麵",D2:D20)
10
2023/1/30交通ICOCA1000
11
2023/1/30餐飲拉麵2200
12
2023/1/30餐飲冰淇淋450
13
2023/1/30購物藥妝2519
14
2023/1/31交通ICOCA1000
15
2023/1/31餐飲藍瓶2431
16
2023/1/31餐飲冰淇淋1220
17
2023/1/31餐飲烏龍麵2400
18
2023/1/31交通ICOCA1000
19
2023/1/31餐飲居酒屋4230
20
2023/1/31餐飲泡麵780
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