what are the steps to calculate data across worksheet ... in easy way
Answers
Answer:
You have multiple worksheets, and now you would like to compile your data spread among those worksheets. To do this:
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.
Tweet
Share
Share
Share
Pin