=SUMPRODUCT(($C$2:$C$1000=ROW(1:10))*($A$2:$A$1000=N256)*($B$2:$B$1000))
我把下面的替换成上面的,得出#N/A应该怎么做才好
=SUMPRODUCT(($C$2:$C$1000={1,2,3,4,5,6,7,8,9,10}
)*($A$2:$A$1000=N256)*($B$2:$B$1000))
=SUMPRODUCT(($C$2:$C$1000=COLUMN(A1:J1))*($A$2:$A$1000=N256)*($B$2:$B$1000))
追问不行啊
追答=SUMPRODUCT(($C$2:$C$1000=COLUMN($A1:$J1))*($A$2:$A$1000=N256)*($B$2:$B$1000))
本回答被提问者采纳