第1个回答 2015-09-22
=SUM(INDIRECT("b1:b"&A1))
或者
=SUM(OFFSET($B$1,,,A1,))
第2个回答 2015-09-22
=SUM($B$1:INDIRECT("B"&A1))
第3个回答 2015-09-22
=SUM(OFFSET(B1,,,A1)
=SUM(INDIRECT("B1:B"&A1)
=SUM(B1:INDEX(B:B,A1))
第4个回答 2015-09-22
C1输入公式:=SUM(OFFSET($B$1,,,$A$1,1))