Multiple work sheets

Hi Dianah

Thank you for your question; and welcome to the forum.

To link one cell to another cell in a different worksheet is straightforward:

1. Select the cell you wish to create the link in.
2. Type in =
3. Select the cell that contains the data you wish to link to.
4. Press Enter.

This creates the link from one cell to another.

If you wish to add data from different cells together, select the cell containing the link and click in the formula bar at the top of the screen, type in + then select the cell that contains the data you want to add to the first cell you selected. Continue typing in + and selecting cells one at a time to include more cells in the calculation.

Always press Enter when you have finished.

If you are multiplying use * instead of +
If you are subtracting use - instead of +
If you are dividing use / instead of +

I hope this helps.
Amanda