To calculate the total sale, you’ll need to pull pricing data from the product sheet.
key in=(the equal sign) into the cell.
This will bring the cell data you selected into the first spreadsheet.
The final formula in this case is=Sheet2!C2.
‘Sheet2’ is the name of the sheet where the data comes from.
This method is good for referencing individual cell data from a different spreadsheet into an original one.
In this example you’d enter:
=IMPORTRANGE(“URL”,“Sheet1!C2”).
Again,URLwould be a full URL.
We’re just keeping it short for example purposes.
You’ll see that the data from the other Sheets spreadsheet file is pulled into this spreadsheet.
ClickSet permissionsand choose to show a warning or restrict editing.
Add a dollar sign ($) before the row and/or column in the reference to make it absolute.
That way, the formula will always refer to the same cell, even when copied and pasted.
