ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
數量
=VLOOKUP(LOOKUP("嫺",B$958:B$958),銷售表!$A:$V,MATCH($A959,銷售表!$2:$2,),)
2
專輯/銷售月份112/01112/02112/03112/04112/05112/06112/07112/08112/09112/10112/11112/12小計
3
CD海2 1 0 1 2 6
4
DVD海0 0 0 0 0 0
5
VCD海0 0 0 0 0 0
6
CD片0 1 0 2 1 4
7
DVD片0 0 0 0 0 0
8
VCD片0 0 0 0 0 0
9
CD歌1 0 0 2 0 3
10
DVD歌0 0 0 0 0 0
11
VCD歌0 0 0 0 0 0
12
CD唱0 1 0 1 0 2
13
DVD唱0 0 0 0 0 0
14
VCD唱0 0 0 0 0 0
15
CD晴1 0 0 (1)1 1
16
CD星0 2 1 1 0 4
17
DVD星0 0 0 0 0 0
18
VCD星0 0 0 0 0 0
19
CD式0 0 2 1 1 4
20
DVD式0 0 (1)0 0 (1)
21
CD取5 0 (1)3 2 9
22
CD閱4 2 5 8 3 22
23
DVD閱0 2 (1)0 1 2
24
CD頁#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
25
合計#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!56
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