Vorlage:Video-Kontenberechnung auf automatisiertem Arbeitsblatt-English

The explanation of each step in detail

This allows you to create account calculations and account aggregates using the "Sum" function on an automated worksheet:

1. Go to the automated worksheet

2. In the master value column, select the cells with the values you want to use for the account calculation/account aggregate. Note: You must always select an empty cell so that the result of the account calculation/account aggregate can be inserted there.

3. Click the "Sum" button in the "Formulas" group in the "*Design" ribbon.

4. The "Account calculation/Create account aggregate" dialog appears. Here you need to define a unique name for the account calculation used, as well as select the account group in which the account values needed for the account calculation are located.

5. From the list area with all account values, left-click to select the account values you want to add - and right-click to subtract. Optionally, you can also set a mathematical operator, a factor and an automatic rounding of the result.

6. Confirm the dialog with "OK".

7. The account calculation/account aggregate is displayed to you in the master value column and automatically written to the MeetingPoint.