OFFSET function in Excel Returns a specified cell or range.
Join the channel Telegram of the AnonyViet 👉 Link 👈 |
How to use the Offset function in Excel
1. The OFFSET function below returns the cell 3 rows below and 2 columns to the right of cell A2. The OFFSET function returns a cell because both the height and width are set to 1.
Result:
2. The OFFSET function below returns a 1 x 2 range that is 8 rows below and 1 column to the right of cell A2. The SUM function calculates the sum of this range.
Result:
The last 2 parameters of the OFFSET function are optional. When height and width are omitted, the new reference has the same height and width as the original reference (first parameter). As always, we’ll use easy-to-understand examples to make things clearer.
3. The OFFSET function below returns the cell with 12 rows below and 0 columns to the right of cell A2.
Result:
4. The OFFSET function below returns a range with 4 rows below and 0 columns to the right of the range B2:C2. The SUM function calculates the sum of this range.
Result:
In addition, you can also view many other excel articles here.