SUMIF & SUMIFS
Conditional sums — total only the rows that match one or more criteria. Every SUMIF / SUMIFS recipe, gotcha, and error fix.
10 pages · 2 reference, 5 how-to, 3 error fix
Reference
How-to guides
SUMIF vs SUMIFS: when to use each in Excel and Sheets
Understand when to use SUMIF (one condition) versus SUMIFS (multiple conditions) for conditional summing in Excel and Google Sheets.
How to use SUMIF with a date range
Use SUMIF with a date comparison criterion to sum values only for dates on or after (or before) a specific date in your data range.
How to use SUMIFS between two dates
Use SUMIFS with two date criteria on the same date column to sum values that fall within a specific start and end date range.
How to use SUMIF with an OR condition
Add multiple SUMIF calls together or use SUMPRODUCT with an OR array to sum values matching any one of several criteria.
SUMPRODUCT vs SUMIFS: weighted and conditional sums in Excel and Sheets
SUMIFS sums by criteria; SUMPRODUCT multiplies arrays before summing. Here is when each wins in Excel and Google Sheets.
Error fixes
Fix 0
SUMIF returns 0 instead of the expected total in Excel and Google Sheets — fix number-as-text, criteria mismatch, range size errors, and data-type issues.
Fix SUMIF
SUMIF not working in Excel and Google Sheets — diagnose formula errors, criteria syntax problems, range mismatches, and wildcard issues.
Fix 0
SUMIFS returns 0 in Excel and Google Sheets — fix criteria order errors, range size mismatches, data-type problems, and AND logic misunderstandings.