Sums in selected rows
Skočit na navigaci
Skočit na vyhledávání
If you want to sum the data in a given column, the procedure is simple. Just right click on the bottom bar and then select the function.
However, if we want, for example, to add only selected rows, the procedure is slightly different.
- Right click on the bottom bar and then select a function (e.g. Sum) - the sum of all rows will be displayed.
- Right mouse click on the resulting sum
- Mode → Selection
- Selection
The window will now display the total for the selected rows.
Modes
All rows - counts all rows
Selection - counts only selected rows
Mixed - if one row is selected, displays calculation for all rows, if more rows are selected, calculates only selected rows.