A formula can include cell references from the worksheet in which it is located but NOT from other worksheets in the workbook.

Question

Quizplus · Accepted Answer

A formula can include cell references from other worksheets in the same workbook by using the worksheet name followed by an exclamation point (!) before the cell reference. For example, if the cell reference is in Sheet2 and the cell being referenced is A1 in Sheet1, the formula would be =Sheet1!A1.

A Formula Can Include Cell References from the Worksheet in Which