質問編集履歴
2
式修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -8,4 +8,4 @@
|
|
|
8
8
|
|
|
9
9
|
|
|
10
10
|
|
|
11
|
-
=IF(SUMPRODUCT(SUBTOTAL(9,INDIRECT("R"&ROW(R5:R7)))(I5:I7=W17)(X5:X7="●"))=0,"",(SUMPRODUCT(SUBTOTAL(9,INDIRECT("R"&ROW(R5:R7)))(I5:I7=W17)(X5:X7="●")))/1000000)
|
|
11
|
+
=IF(SUMPRODUCT(SUBTOTAL(9,INDIRECT("R"&ROW(R5:R7)))*(I5:I7=W17)*(X5:X7="●"))=0,"",(SUMPRODUCT(SUBTOTAL(9,INDIRECT("R"&ROW(R5:R7)))*(I5:I7=W17)*(X5:X7="●")))/1000000)
|
1
タイトル変更
test
CHANGED
|
@@ -1 +1 @@
|
|
|
1
|
-
Excel SUMPRODUCT
|
|
1
|
+
Excel SUMPRODUCTを再現させる式
|
test
CHANGED
|
File without changes
|