📊
LibreOffice Calc SUMIF Master Tutorial & Example
View Example
⚡ Automated Real-Time Calculations & Examples

Master SUMIF in LibreOffice Calc with Practical Examples

Stop manually calculating totals every time you add a row! Learn with visual screenshots and a concrete example how to connect a continuously updated Daily Log sheet to a live Summary sheet.

📝

Dynamic Daily Log

Keep adding daily rows without worrying about changing formula ranges.

📸

Visual Step-by-Step

Annotated LibreOffice screenshot graphics guiding every formula entry.

🎯

Worked-Out Example

Clear math verification showing how entries sum up automatically.

1 Step 1

Set Up Sheet 1 ("Daily Log")

This tab acts as your primary data entry log. You will continually append new transactions here throughout the day or month.

📋 Detailed Setup Steps:

  • • Open LibreOffice Calc and right-click the bottom sheet tab (e.g., Sheet1). Select Rename Sheet... and type Daily Log.
  • • Set up three clean column headers in Row 1:
Col A
Date 📅
Col B
Category 🏷️
Col C
Amount 💵
💡 Pro Tip: You can enter multiple transactions for the exact same date or category—the formula will handle them automatically!
LibreOffice Calc - Daily Log Setup
Sheet 1
LibreOffice Calc Daily Log Sheet Setup
LibreOffice Calc - Summary Sheet Setup
Sheet 2
LibreOffice Calc Summary Sheet Setup
2 Step 2

Set Up Sheet 2 ("Summary")

The Summary sheet holds your unique categories (or dates) and automatically computes real-time aggregated totals from your Daily Log.

🛠️ Adding the Summary Sheet:

  • • Click the + (Add Sheet) button located at the bottom left navigation bar.
  • • Right-click the newly created sheet tab and rename it to Summary.
  • • Create two headers in Row 1:
Column A
Category
(e.g., Food, Transport)
Column B
Total Amount
(Holds automated SUMIF)
3 Step 3

Add the Automatic SUMIF Formula

Now, enter the powerful SUMIF formula into Cell B2 of your Summary sheet.

⚡ Formula for Category Totals (Cell B2)
=SUMIF('Daily Log'.B:B, A2, 'Daily Log'.C:C)

🔍 Formula Anatomy Breakdown:

'Daily Log'.B:B
Search Range: Scans the entire Category column (Column B) in the 'Daily Log' sheet.
A2
Criterion: Matches the specific category name in cell A2 (e.g., "Food").
'Daily Log'.C:C
Sum Range: Adds together all numbers in Column C where the category matches.

📅 Alternative: Totaling by Date

By Date

If Column A on your Summary sheet lists Dates instead of categories, use this version:

=SUMIF('Daily Log'.A:A, A2, 'Daily Log'.C:C)
LibreOffice Calc - Formula Entry
Formula Bar
LibreOffice Calc Formula Entry Screenshot
💡 Concrete Worked Example

Let's Walk Through an Example Step-by-Step

Suppose you logged 6 daily expenses across 3 different categories in your Daily Log sheet. Here is exactly how LibreOffice Calc computes the totals in your Summary sheet.

Sheet 1: Daily Log (Input Data)

6 Entries
Row Col A (Date) Col B (Category) Col C (Amount)
2 2026-03-20 🍔 Food $18.50
3 2026-03-20 🚗 Transport $12.00
4 2026-03-21 🍔 Food $32.75
5 2026-03-21 💡 Utilities $85.00
6 2026-03-22 🚗 Transport $15.50
7 2026-03-22 🎬 Entertainment $45.00

Sheet 2: Summary (Live SUMIF Result)

Automated
Row Col A (Category) Col B (Total Amount) Calculation Math
2 Food $51.25 $18.50 + $32.75
3 Transport $27.50 $12.00 + $15.50
4 Utilities $85.00 $85.00
5 Entertainment $45.00 $45.00

🔬 How LibreOffice Calc Processes =SUMIF('Daily Log'.B:B, A2, 'Daily Log'.C:C) for Cell B2 ("Food"):

Step A: Filter Scan

Calc looks down Column B of 'Daily Log' and finds rows 2 and 4 where the value is equal to "Food" (matches cell A2).

Step B: Value Retrieval

It fetches the corresponding values from Column C for those matching rows: Row 2 ($18.50) and Row 4 ($32.75).

Step C: Instant Sum

Calc adds $18.50 + $32.75 to return $51.25 dynamically into cell B2!

🎮 Live Interactive Sandbox

Test the Worked Example Live

Add new entries below and watch how the LibreOffice Calc SUMIF formula calculates real-time totals in the Summary tab!

📊
Daily_Budget_Log.ods LibreOffice Calc Dynamic Simulation
Summary By:
f(x) | Select a summary total cell to inspect formula

➕ Add New Log Entry

Row Column A (Date) Column B (Category) Column C (Amount) Action

Important Syntax Rules & Differences

Key differences between LibreOffice Calc and Microsoft Excel when referencing sheets.

🟢 LibreOffice Calc Syntax

LibreOffice uses a dot (.) to separate the sheet name from the column or cell reference.

'Daily Log'.B:B
🔷 Microsoft Excel Syntax

Excel uses an exclamation point (!) instead of a dot.

'Daily Log'!B:B

❓ Common Troubleshooting Tips

Typing Sheet Names accurately: If your sheet name contains spaces (like Daily Log), you MUST enclose it in single quotes: 'Daily Log'.
Exact Category Matching: SUMIF is case-insensitive, but trailing spaces (e.g., "Food " vs "Food") will prevent matches.
Full Column References: Using B:B references the entire column so you never have to adjust row bounds when adding new entries.
✅ Formula copied to clipboard!