For i = 6 To 18 Worksheets("支払いまとめ").Cells(i2 + 1, i).Value =_ Evaluate("SumProduct((Worksheets(支払い実績一覧).Range(C3:C20000)_ = Worksheets(支払いまとめ).cells(2," & i & "))_ * (Worksheets(支払い実績一覧).Range(H3:H20000) =_ Worksheets(支払いまとめ).cells(" & i2 & "+1,5))_ , (Worksheets(支払い実績一覧).Range(X3:X20000)))") Next i