sorry,写反了,a的范围是1到10,求和的范围是A1到J1,即
a=1, c2=A1,
a=2, c2=A1+B1,
a=10,c2=sum(A1:J1)
è§æªå¾
B1è¾å ¥
=SUM(INDIRECT("a1:A"&A1))
å¦æaçå¼æ¾å°D2çè¯
B1è¾å ¥
=SUM(INDIRECT("a1:A"&D2))
追é®è°¢è°¢åï¼ææé®é¢ååäºï¼é£æ¯å¯¹äºåçï¼å¦ææ¯è¡å¢
æ±å¼èå´æ¯A1å°J1
如果范围是A1到J1呢,该怎么写
追答A1到J1中包含了B1, 为不出现错误,你可在C2输入:=IFERROR(SUM(A1:INDIRECT("J"&A1)),0)
A1到J1中包含了B1, 为不出现错误,你可在C2输入:=IFERROR(SUM(A1:INDIRECT("J"&A1)),0)