回答編集履歴

1

修正

2021/06/09 15:39

投稿

jinoji
jinoji

スコア4592

test CHANGED
@@ -1,6 +1,6 @@
1
1
  ```
2
2
 
3
- Sheet2.Range("C3").Formula2 = "=SUMIFS(Sheet1!$D:$D,Sheet1!$B:$B,Sheet2!B3:B6,Sheet1!$C:$C,Sheet2!C2:H2)"
3
+ Sheet2.Range("C3").Formula2 = "=SUMIFS(Sheet1!D:D,Sheet1!B:B,B3:B6,Sheet1!C:C,C2:H2)"
4
4
 
5
5
 
6
6