第1个回答 2021-08-09
=sumproduct(indirect(sumif(indirect("'"&row($1:$40)&"'!a:a"),“合计”,indirect("'"&row($1:$40)&"'!b:b")))假设每表合计对应数据在b列
第2个回答 2021-08-09
=SUMPRODUCT(SUMIF(INDIRECT("'"&ROW($1:$40)&"'!A:A"),"合计",INDIRECT("'"&ROW($1:$40)&"'!L:L")))本回答被提问者采纳