Excel2010中,横着拉公式如何不改变竖列只改变横列,求大神指点一下。_百...答:经过测试,如下4个公式正确=SUM(OFFSET('2.10'!$H$4,COLUMN(A1)-1,),OFFSET('2.10'!$H$32,COLUMN(A1)-1,))=SUM(INDEX('2.10'!$H:$H,COLUMN(A1)+3),INDEX('2.10'!$H:$H,COLUMN(A1)+31))=SUM(INDIRECT("'2.10'!H"&COLUMN(A1)+3),INDIRECT("'2.10'!H"&COLUMN(A1)...