[已解决]求各位朋友帮我看看这个公式

凤凰琴

求各位朋友帮我看看这个公式
=SUMPRODUCT((Sheet1!I$2:I$471=Sheet2!A2)*(MATCH(Sheet1!I$2:I$471&Sheet1!J$2:J$471,Sheet1!I$2:I$471&Sheet1!J$2:J$471,)=ROW($1:$99)))
为什么跨表计算，公式会出错误？？
表格在附件

最佳答案

月排行榜 / 总排行榜

苏子龙

2016-9-3 23:43

=SUMPRODUCT((Sheet1!I$2:I$471=Sheet2!A2)*(MATCH(Sheet1!I$2:I$471&Sheet1!J$2:J$471,Sheet1!I$2:I$471&Sheet1!J$2:J$471,)=ROW($1:$470)))

跳转到最佳答案楼层

苏子龙

=SUMPRODUCT((Sheet1!I$2:I$471=Sheet2!A2)*(MATCH(Sheet1!I$2:I$471&Sheet1!J$2:J$471,Sheet1!I$2:I$471&Sheet1!J$2:J$471,)=ROW($1:$470)))

凤凰琴

苏子龙 发表于 2016-9-3 23:43
=SUMPRODUCT((Sheet1!I$2:I$471=Sheet2!A2)*(MATCH(Sheet1!I$2:I$471&Sheet1!J$2:J$471,Sheet1!I$2:I$471&S ...

谢谢