EXCEL OFFSET

The OFFSET function is an Excel function that returns a cell or a cell of range based on row and column numbers.

Syntax:

=offset(reference,rows,columns,[height],[width])

Arguments or Parameters

reference: refer to a cell that acts a formula starting point.
rows: rows refers to the number of rows the formula moves up or down from the starting point.
cols: cols is the number of columns the formula moves left or right from the starting point.
height [optional]: the height in rows of the returned reference
width [optional: the width in columns of the returned reference

Objective: Calculate the Total score of player1 from week1 to week2 in cell H5.

Step 1:

Type = sign in cell H5.
Type OFFSET Function

Step 2:

Select A3 as a reference
Type “,”

Step 3:

Select 2 in rows
Type “,”
Select 1 in columns
Type “,”

Step 4:

Select height as 1
Type “,”
Select width as 4
Type “,”
Close bracket with “)”
Press Enter

Conclusion: The offset has select the week1-week4 range of Player 2(B5:E5)

Note: In order to calculate the sum of player 2 use the below formula.

=sum(offset(A3,2,1,1,4)