You can reference an entire column or an entire row in a function argument by listing only the column or only the row.

Question

Quizplus · Accepted Answer

This is true. In many cases, you only need to reference an entire column or an entire row, and you can do so by listing only the column or only the row. For example, if you want to sum all the values in column B, you can use the formula "=SUM(B:B)". Similarly, if you want to find the average of all the values in row 5, you can use "=AVERAGE(5:5)".

You Can Reference an Entire Column or an Entire Row