Enter $1:$65536 to select the entire sheet. =SUM(INDEX($1:$65536,5,3):INDEX($1:$65536, Step 5: Write the row_num Argument of the INDEX Function Type 5 as the row number for cell G5, and as the second reference cell, row_num is 5. =SUM(INDEX($1:$65536,5,3):INDEX($1:...