slogan
专业知识问答平台！
例如：求A列前n行的和
（n=B列的和）
=SUM(INDIRECT("A1:A"&SUM(B:B)))
=SUM(A1:INDIRECT("A"&SUM(B:B)))
=SUM(A1:INDIRECT(ADDRESS(SUM(B:B),1)))
=SUM(A1:INDEX(A:A,SUM(B:B)))
=SUM(OFFSET(A1,,,SUM(B:B)))
©本文版权归作者所有，任何形式转载请联系我们：xiehuiyue@offercoming.com。
