Question

How to calculate data across worksheets??​

Answer 1

❣️Heya here is the ans of your qun❣️

|| FOLLOW THESE STEPS ||

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

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

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

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

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

6) 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.

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

HOPE IT HELPS U (. ❛ ᴗ ❛.)

❣️HAPPY NEW YEAR SUSHMA ❣️

Answer 2

How to calculate data across worksheets

worksheets:

A grid of cells makes up an Excel worksheet. Data, tables, charts, etc. may be included. Read Work with worksheets using the Excel JavaScript API to find out more about the worksheet object model.

the following steps are:

1. Choose the cell where you want the formula to appear.
2. Wherever you want it, enter the formula.
3. Select the spreadsheet containing the data by clicking on it.
4. Enter the desired operator (such as +, -, /, *, etc.).
5. Choose the cell or cell range to be included by clicking the subsequent worksheet that contains the extra data you wish to utilize.
6. Repeat this method until you are finished, and then complete your formula with a closing parenthesis. If desired, enter the operator (+, -, /, *, etc.) that you would want to employ.
7. Press “Enter” and you will be returned to your Summary sheet, or wherever you began your calculation across worksheets.