SUM With OFFSET Functions | Advance Excel | Rohit Narang
The OFFSET function is one of the built-in functions in Microsoft Excel.
Its purpose is to return a range that is a specified number of rows and columns from a reference cell or range.
The range that the OFFSET function returns can be a single cell or a range of multiple adjacent cells.
When returning a range, OFFSET allows you to specify the size by inserting the number of rows and columns.
The syntax of the OFFSET function
=OFFSET(reference, rows, cols, [height], [width])
Data Validation Video Link : • Chapter 15 Data Validation