To reference cells in other sheets in a workbook when creating a formula,include the worksheet name rather than the cell reference.

Name: To reference cells in other sheets in a workbook when creating a formula,include the worksheet name rather than the cell reference.
Brand: Quizplus
Rating: 4.8 (34 reviews)

Question

Quizplus · Accepted Answer

To reference cells in other sheets, you include both the worksheet name and the cell reference, typically in the format 'SheetName'!CellReference.

To Reference Cells in Other Sheets in a Workbook When