656 views
3 votes
On the Summary sheet, in cell D3, enter a formula to display the value of cell B34 from the March sheet.

1 Answer

5 votes

Final answer:

To reference cell B34 from the March sheet in cell D3 on the Summary sheet, the formula is '=March!B34'. This formula allows the value in March's cell B34 to appear in the Summary's cell D3.

Step-by-step explanation:

To display the value of cell B34 from the March sheet in cell D3 on the Summary sheet, you would enter the following formula in cell D3: =March!B34. This formula is telling the spreadsheet to pull the data from cell B34 on the sheet named March and display it in cell D3 on the Summary sheet. If you have different names for your sheets or cells, be sure to replace 'March' and 'B34' with the correct references.

User MESepehr
by
8.2k points