=SUM(OFFSET(C3:E5,-1,0,3,3)) sums the range C2:E4 : OFFSET « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Lookup Reference functions
  3. OFFSET
Input the formula: =SUM(OFFSET(C3:E5,-1,0,3,3)). Press Enter to get the result.
Input the formula: =SUM(OFFSET(C3:E5,-1,0,3,3))








19.12.OFFSET
19.12.1.OFFSET(reference,rows,cols,height,width) returns a reference offset from a given referenceOFFSET(reference,rows,cols,height,width) returns a reference offset from a given reference
19.12.2.=OFFSET(A3,-2,0)=OFFSET(A3,-2,0)
19.12.3.=OFFSET(A3,0,-2)=OFFSET(A3,0,-2)
19.12.4.=SUM(OFFSET (A3,1,2,50,1)).=SUM(OFFSET (A3,1,2,50,1)).
19.12.5.=OFFSET(C3,2,3,1,1) displays the value in cell F5=OFFSET(C3,2,3,1,1) displays the value in cell F5
19.12.6.=SUM(OFFSET(C3:E5,-1,0,3,3)) sums the range C2:E4=SUM(OFFSET(C3:E5,-1,0,3,3)) sums the range C2:E4
19.12.7.=OFFSET(C3:E5,0,-3,3,3) returns an error, because the reference is not on the worksheet=OFFSET(C3:E5,0,-3,3,3) returns an error, because the reference is not on the worksheet