回答編集履歴

1

修正

2021/09/18 08:29

投稿

jinoji
jinoji

スコア4585

test CHANGED
@@ -1,5 +1,5 @@
1
1
  ```
2
2
 
3
- =SUM(入力!$B$5:$CE$200*(入力!$A$3:$CD$3=$C2)*(入力!$A$5:$CD$200>=$M$3)*(入力!$A$5:$CD$200<=$M$5))
3
+ =SUM(入力!$B$5:$CE$20*(入力!$A$3:$CD$3=$C2)*(入力!$A$5:$CD$20>=$M$3)*(入力!$A$5:$CD$20<=$M$5))
4
4
 
5
5
  ```