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