If a formula references a cell or range outside the table relative references should be used.

Name: If a formula references a cell or range outside the table relative references should be used.
Brand: Quizplus
Rating: 4.9 (43 reviews)

Question

Quizplus · Accepted Answer

When referencing a cell or range outside the table, absolute references (or mixed references, depending on the need) should be used to ensure the reference remains constant even if the formula is copied or the table moves.

If a Formula References a Cell or Range Outside the Table