With the specified reference as the frame of reference, a new reference is obtained by the given offset. The returned reference can be a cell or a range of cells. And can specify
The number of rows or columns returned.
grammar
OFFSET(reference,rows,cols,height,width)
■ Reference The reference area used as the offset reference frame. Reference must be a reference to a cell or region of adjoining cells.
Otherwise, OFFSET returns the error #VALUE! .
■ Rows The number of rows that are offset from the upper-left cell of the offset reference frame. If 5 is used as the argument ROWS, the target argument is stated
Use the upper-left cell of the range 5 lines below reference.
The number of lines can be positive (below the starting reference) or negative (above the starting reference).
■ Cols The number of columns that are left (right) offset from the upper-left cell of the offset reference frame. If 5 is used as the parameter Cols, the target reference area is indicated
The upper-left cell of the field is five columns to the right of reference.
The number of columns can be positive (to the right of the starting reference) or negative (to the left of the starting reference).
■ Height Height, that is, the number of lines of the reference area to return. Height must be positive.
■ Width width, that is, the number of columns in the reference area to be returned. Width must be positive.
Instructions
■ If the number of rows and columns is OFFSET beyond the edge of the sheet, the function offset returns the error #REF! .
If height or width is omitted, it is assumed to be the same height or width as the reference.
The function OFFSET doesn’t actually move any cells or change the selection, it just returns a reference. The function OFFSET can be used for anything you need
A function that takes a reference as an argument. For example, the formula SUM(OFFSET(C2,1,2,3,1)) will calculate the total value of the region of 3 rows and 1 column that is 1 row below and 2 columns to the right of cell C2.
I want to create a clean, concise and efficient office reference manual, in order to maintain a good reference experience, I did not add any third-party advertisements in my blog, of course, if you are willing, you can watch the following video, it can bring me some income, so that I can better maintain the server to provide higher quality service, thank you for your help and support.
You can choose any link below to watch my videos and I will earn some money to strengthen the site and resist DDOS attacks that may happen at any time, thank you for your support!
(Please note: Please do not maliciously click on links or video ads to increase invalid traffic, as this can result in lower or no revenue.)
Learn to consult the manual video
(Will be released in the later period with the consult the manual article, please pay attention.)
My Febspot video list (Learn after-school relaxation videos)
https://suu.us/sponsor
My Febspot video home page
https://www.febspot.com/leet4477/