Entering an equal sign followed by another cell's address in a blank cell exports the referenced cell's contents to the new location in Excel. However, using this technique creates a link between ...

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

Doing this tells Excel to add the June and July cell values to create a total. When people view the Total worksheet, they will see total sales for June and July in the worksheet's B1 cell.