ABCDEFG
1
サンプルデータサンプル数式 (色付きのセルは式が入ってます)
2
日付来場者数入場料単価単純な掛け算ARRAYFORMULAラベルに式を入れる場合#REF!
3
2021/11/011,3192,0002,638,0002,638,0002,638,000このテキストのように
4
2021/11/021,7262,0003,452,0003,452,0003,452,000間にデータを入れると
5
2021/11/039432,0001,886,0001,886,0001,886,000エラーが出てしまいます
6
2021/11/045102,0001,020,0001,020,0001,020,000
7
2021/11/056282,0001,256,0001,256,0001,256,000
8
2021/11/061,9112,0003,822,0003,822,0003,822,000
9
2021/11/071,6272,0003,254,0003,254,0003,254,000
10
2021/11/081,4752,0002,950,0002,950,0002,950,000
11
2021/11/091,9422,0003,884,0003,884,0003,884,000
12
2021/11/101,0652,0002,130,0002,130,0002,130,000
13
2021/11/111,9382,0003,876,0003,876,0003,876,000
14
2021/11/121,8202,0003,640,0003,640,0003,640,000
15
2021/11/137302,0001,460,0001,460,0001,460,000
16
2021/11/141,5932,0003,186,0003,186,0003,186,000
17
2021/11/155112,0001,022,0001,022,0001,022,000
18
2021/11/161,1252,0002,250,0002,250,0002,250,000
19
2021/11/171,8042,0003,608,0003,608,0003,608,000
20
2021/11/181,5972,0003,194,0003,194,0003,194,000
21
2021/11/191,8212,0003,642,0003,642,0003,642,000
22
2021/11/201,0132,0002,026,0002,026,0002,026,000
23
2021/11/216692,0001,338,0001,338,0001,338,000
24
2021/11/221,7522,0003,504,0003,504,0003,504,000
25
2021/11/231,7112,0003,422,0003,422,0003,422,000
26
2021/11/241,0922,0002,184,0002,184,0002,184,000
27
2021/11/257892,0001,578,0001,578,0001,578,000
28
2021/11/261,8602,0003,720,0003,720,0003,720,000
29
2021/11/276112,0001,222,0001,222,0001,222,000
30
2021/11/281,6832,0003,366,0003,366,0003,366,000
31
2021/11/291,0062,0002,012,0002,012,0002,012,000
32
2021/11/301,2402,0002,480,0002,480,0002,480,000
33