发布网友 发布时间:2022-05-03 11:53
共4个回答
热心网友 时间:2022-06-19 17:18
=IF(B1<>"",SUM(A1:INDIRECT("a"&B1)),"")或SUM(A1:INDIRECT("a"&B1))热心网友 时间:2022-06-19 17:19
=SUM(A1:INDEX(A:A,B1,1))热心网友 时间:2022-06-19 17:19
=sum(indirect("a1:a"&b1))热心网友 时间:2022-06-19 17:20
=SUM(INDIRECT("A1:A"&B1))