When a new row or column is inserted in a range of cells used in a function, the range in the function is not automatically adjusted to include that new row or column.

Question

Quizplus · Accepted Answer

In many spreadsheet applications like Microsoft Excel and Google Sheets, when a new row or column is inserted within a range of cells that are referenced in a function, the range within the function is automatically adjusted to include the new row or column.

When a New Row or Column Is Inserted in a Range