What are These Row /Column Functions Doing in my Excel Formulas?

Microsoft Excel Tips and Tricks

ROW(S)/COLUMN(S) functions are an efficient way to write formulas that require copying down columns, across rows, or both. However, many users get caught out by these functions because you don’t edit the cell references in the same way you might with other formulas.

Credit MyOnlineTrainingHub