Question

Steps to calculate data across worksheets

Answer 1

Answer:

This is how you can do it:

Select the cell where you would like the formula to appear, probably on a new “Summary Worksheet.”

Enter the formula until you get to the point of entering a cell reference or range.

Click the worksheet with the data you would like included, and select the cell or cell range that you would like to use.

Enter the operator (+, -, /, *, etc.) that you would like to use.

Click the next worksheet with the additional data you would like to use, and select the cell or cell range to be included.

If desired, enter the operator (+, -, /, *, etc.) that you would like to use, and repeat this process until you are done, and end your formula with a closing parenthesis.

Press “Enter” and you will be returned to your Summary sheet, or wherever you began your calculation across worksheets.

Hope this helps you.