How to “group by” and sum in Excel

In the following example we used the Subtotal feature to create a spreadsheet that shows the partial sum based on another column.

Methodology:

1. Click the Data tab in Excel’s ribbon toolbar
2. Click the Sort button to sort our data by the user column
3. Click the Subtotal button and fill in the dialog as appropriate, then click OK

In our example, we had only two columns (User and Lot), we wanted to produce the total sum of lots per user and so filled the dialog as follows:

What the above options do is the following:

• Use the User column to group on by checking when its value changes
• Use the Sum function on the columns that will be selected later on
• Apply the function on the Lot column

How to “group by” and sum or count in LibreOffice Calc (Excel)

In the world of spreadsheet applications, LibreOffice Calc stands out as a versatile and powerful tool for managing data. It offers a wide array of features that can help you organize, analyze, and make sense of your data. One of these features, often underutilized, is the Subtotals functionality. In this…

28 October 2023

In "Applications"

How to randomize order of rows in Excel

In the following video we demonstrate how to randomize the rows of an Excel sheet. Methodology: We created a new column next to the data we want to randomize their order, then we typed in the first cell the following formula =rand(). =rand() will generate a random value between 0…

14 May 2016

In "Office"

LibreOffice Calc: get the distinct/unique values in a column or a list of elements

These videos demonstrate how to get the distinct/unique values in a column or a list of elements in LibreOffice Calc. Procedure to get the distinct values in a column or a list of elements: Select the column (or the list of data) that you want to process Click on the…

14 January 2018

In "Applications"

This post is also available in: Greek