A1=SUM(OFFSET(A1,0,1,,4))
那就别用SUM函数直接在A1输入公式=B1+D1+E1+F1这样你怎么添加列都不会变
=SUM(INDIRECT(ADDRESS(ROW(),2)&":"&ADDRESS(ROW(),5)))
