Totals by category
Sum revenue, costs, or units sold for one category such as Software or Services.
Spreadsheet utility
SUMIF and SUMIFS Formula Generator
SUMIF and SUMIFS sit behind a lot of spreadsheet reporting. This page helps you move from reporting question to working total without mixing up the criteria ranges.
Use this page when the answer should be a total, not a row count. Build conditional sum formulas for Excel and Google Sheets from plain English.
One-condition and multi-condition supportReporting-friendly examplesWorks in Excel and Sheets
Overview
Use SUMIF and SUMIFS when the question is how much, not how many
Conditional sums are everywhere in spreadsheet reporting. They power sales summaries, monthly reviews, finance trackers, and category-based dashboards where the answer needs to be an amount, not a count.
The hardest part is usually not the logic itself. It is remembering when to use SUMIF versus SUMIFS, stating the criteria cleanly, and making sure every range lines up correctly.
How to use it
How to describe a conditional total clearly
Step 1
Describe what you want to total and what conditions should apply.
Step 2
Choose Excel or Google Sheets.
Step 3
Copy the formula and confirm that each criteria range lines up with the sum range.
Use cases
Reporting and dashboard totals this page is built for
Date-based summaries
Calculate totals for a month, quarter, deadline window, or current reporting period.
Multi-criteria reporting
Add up values that meet more than one condition such as region plus team or status plus amount.
Practical examples
Conditional totals you can copy and adapt
These examples focus on the kinds of totals people build in revenue reports, finance trackers, and performance dashboards.
One condition
Prompt: Sum sales in C:C where region in B:B is East
Example formula
=SUMIF(B:B,"East",C:C)Adds values in column C only when the corresponding region in column B is East.
Category total
Prompt: Sum revenue where category is Software
Example formula
=SUMIF(B:B,"Software",C:C)Calculates a total for rows where the category in B matches Software.
Month and team
Prompt: Sum orders where month is March and team is North
Example formula
=SUMIFS(D:D,B:B,"March",C:C,"North")Adds the values in D:D only when both conditions are true: month is March and team is North.
Paid invoices over threshold
Prompt: Sum invoices where status is Paid and amount is above 100
Example formula
=SUMIFS(C:C,B:B,"Paid",C:C,">100")Totals only invoice values in C:C for rows marked Paid and above 100.
The difference
Use SUMIF for one condition and SUMIFS for several
SUMIF is the lighter version when you only need one rule. SUMIFS is the better fit when you need two or more conditions applied at the same time.
Knowing which one to reach for keeps formulas shorter and easier to review, especially when a dashboard grows over time.
Where errors happen
Conditional sums fail when ranges do not align cleanly
The most common problem with SUMIFS is mismatched range sizes. If the sum range and criteria ranges do not cover the same rows, the formula becomes unreliable or returns an error.
This page also helps separate SUMIF and SUMIFS from COUNTIF and COUNTIFS, because many spreadsheet users start with the right criteria but the wrong kind of function.
FAQ
Frequently asked questions
What is the difference between SUMIF and SUMIFS?
SUMIF handles one condition. SUMIFS handles multiple conditions at the same time.
How is this different from COUNTIF and COUNTIFS?
Use SUMIF and SUMIFS when you need to add values. Use COUNTIF and COUNTIFS when you need to count matching rows instead of totaling an amount.
Can I use this with dates?
Yes. Conditional sums based on dates, months, and ranges are common use cases for both Excel and Google Sheets.
Does this work in both Excel and Google Sheets?
Yes. The tool can generate output for either platform.
What if my criteria are text values?
That is very common. SUMIF and SUMIFS work well for categories, regions, names, statuses, and other text-based criteria.
Can this help with reports and dashboards?
Yes. These functions are used constantly in reporting, finance, and operational dashboards.
Next pages
Need counts instead of totals?
If the answer you need is the number of matching rows rather than an amount to add up, move to COUNTIF and COUNTIFS instead.
COUNTIF and COUNTIFS Formula Generator
Count matching rows for KPIs, trackers, and status-based spreadsheet summaries.
IF Formula Generator
Turn thresholds, blank checks, and status rules into IF and nested IF formulas.
Excel Formula Generator
Start from a plain-English task and get a full Excel formula you can adapt.
Formula Examples
Browse copy-ready reference formulas before generating something more custom.