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.

Using the Wrong Cell Reference Many Excel users don't understand cell references in Excel. You have a relative reference (e.g., =A1), which changes the row and column based on the cell it's copied to.