Subtotals in LibreOffice Calc

What is Subtotal?

Subtotal in LibreOffice Calc is a feature used to calculate summary data, such as sums, averages, counts, or other aggregate functions, for grouped data in a spreadsheet.

Steps to Use Subtotal in LibreOffice Calc:

  1. Organize Data: Ensure the data is sorted by the column on which you want to calculate the subtotal.
  2. Access Subtotal Tool: Go to Data > Subtotals from the menu bar.
  3. Set Options:
    • Group By: Select the column to group the data (e.g., "Category").
    • Calculate Subtotals For: Choose the numeric column for the subtotal (e.g., "Amount").
    • Use Function: Select the aggregate function (e.g., Sum, Average, Count).
  4. Apply: Click OK, and the subtotals will be calculated and displayed in the spreadsheet.

Example:

Here is an example dataset:

Category Amount
A 100
A 200
B 150
B 250

After applying Subtotals for "Amount" grouped by "Category" using the Sum function:

Category Amount
A 100
A 200
Subtotal A 300
B 150
B 250
Subtotal B 400

Key Points for Exams:

  • Subtotals simplify data analysis by providing summaries for grouped data.
  • Useful functions include SUM, AVERAGE, and COUNT.
  • Ensure data is sorted before applying subtotals for accurate results.