Vorlage:Video-Kontenberechnung auf automatisiertem Arbeitsblatt-English
This allows you to create account calculations and account aggregates using the "Sum" function on an automated worksheet:
-
Go to the automated worksheet
-
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.
-
Click the "Sum" button in the "Formulas" group in the "*Design" ribbon.
-
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.
-
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.
-
Confirm the dialog with "OK".
-
The account calculation/account aggregate is displayed to you in the master value column and automatically written to the MeetingPoint.