A | B | C | D | E | F | G | ||
---|---|---|---|---|---|---|---|---|
1 | サンプルデータ | サンプル数式 (色付きのセルは式が入ってます) | ||||||
2 | 日付 | 来場者数 | 入場料単価 | 単純な掛け算 | ARRAYFORMULA | ラベルに式を入れる場合 | #REF! | |
3 | 2021/11/01 | 1,319 | 2,000 | 2,638,000 | 2,638,000 | 2,638,000 | このテキストのように | |
4 | 2021/11/02 | 1,726 | 2,000 | 3,452,000 | 3,452,000 | 3,452,000 | 間にデータを入れると | |
5 | 2021/11/03 | 943 | 2,000 | 1,886,000 | 1,886,000 | 1,886,000 | エラーが出てしまいます | |
6 | 2021/11/04 | 510 | 2,000 | 1,020,000 | 1,020,000 | 1,020,000 | ||
7 | 2021/11/05 | 628 | 2,000 | 1,256,000 | 1,256,000 | 1,256,000 | ||
8 | 2021/11/06 | 1,911 | 2,000 | 3,822,000 | 3,822,000 | 3,822,000 | ||
9 | 2021/11/07 | 1,627 | 2,000 | 3,254,000 | 3,254,000 | 3,254,000 | ||
10 | 2021/11/08 | 1,475 | 2,000 | 2,950,000 | 2,950,000 | 2,950,000 | ||
11 | 2021/11/09 | 1,942 | 2,000 | 3,884,000 | 3,884,000 | 3,884,000 | ||
12 | 2021/11/10 | 1,065 | 2,000 | 2,130,000 | 2,130,000 | 2,130,000 | ||
13 | 2021/11/11 | 1,938 | 2,000 | 3,876,000 | 3,876,000 | 3,876,000 | ||
14 | 2021/11/12 | 1,820 | 2,000 | 3,640,000 | 3,640,000 | 3,640,000 | ||
15 | 2021/11/13 | 730 | 2,000 | 1,460,000 | 1,460,000 | 1,460,000 | ||
16 | 2021/11/14 | 1,593 | 2,000 | 3,186,000 | 3,186,000 | 3,186,000 | ||
17 | 2021/11/15 | 511 | 2,000 | 1,022,000 | 1,022,000 | 1,022,000 | ||
18 | 2021/11/16 | 1,125 | 2,000 | 2,250,000 | 2,250,000 | 2,250,000 | ||
19 | 2021/11/17 | 1,804 | 2,000 | 3,608,000 | 3,608,000 | 3,608,000 | ||
20 | 2021/11/18 | 1,597 | 2,000 | 3,194,000 | 3,194,000 | 3,194,000 | ||
21 | 2021/11/19 | 1,821 | 2,000 | 3,642,000 | 3,642,000 | 3,642,000 | ||
22 | 2021/11/20 | 1,013 | 2,000 | 2,026,000 | 2,026,000 | 2,026,000 | ||
23 | 2021/11/21 | 669 | 2,000 | 1,338,000 | 1,338,000 | 1,338,000 | ||
24 | 2021/11/22 | 1,752 | 2,000 | 3,504,000 | 3,504,000 | 3,504,000 | ||
25 | 2021/11/23 | 1,711 | 2,000 | 3,422,000 | 3,422,000 | 3,422,000 | ||
26 | 2021/11/24 | 1,092 | 2,000 | 2,184,000 | 2,184,000 | 2,184,000 | ||
27 | 2021/11/25 | 789 | 2,000 | 1,578,000 | 1,578,000 | 1,578,000 | ||
28 | 2021/11/26 | 1,860 | 2,000 | 3,720,000 | 3,720,000 | 3,720,000 | ||
29 | 2021/11/27 | 611 | 2,000 | 1,222,000 | 1,222,000 | 1,222,000 | ||
30 | 2021/11/28 | 1,683 | 2,000 | 3,366,000 | 3,366,000 | 3,366,000 | ||
31 | 2021/11/29 | 1,006 | 2,000 | 2,012,000 | 2,012,000 | 2,012,000 | ||
32 | 2021/11/30 | 1,240 | 2,000 | 2,480,000 | 2,480,000 | 2,480,000 | ||
33 |