Images are reused AI-generated editorial illustrations, not documentary photographs or verified product screenshots.
A Google Sheets SUMIF formula adds values that match one condition. It answers an amount question, not a count question. Define the criteria column, matching rule and amount column before using a total in a client report, especially when the data includes text numbers, refunds or inconsistent labels.
Align criteria with the correct amounts
With categories in A2:A4 and numeric amounts in B2:B4, =SUMIF(A2:A4,"Travel",B2:B4) adds Travel amounts. Check that the criteria and amount ranges represent corresponding records. Do not accidentally add a unit price column when the intended measure is a full transaction amount. Field meaning matters as much as syntax.
Use a deliberate matching rule
Review the current SUMIF documentation for criteria syntax, comparisons and wildcards. A wildcard can include labels you did not intend. Decide how blank categories, spelling differences and negative amounts should be treated under the reporting definition. SUMIF supports one criterion; several criteria call for an appropriately designed different formula.
Reconcile the selected records
List the matched synthetic rows and add their amounts independently. Compare the subset total with the full source total where meaningful. Check inserted rows and data stored as text. Do not describe a technically successful formula as an accounting decision or assume that every included transaction is approved or tax-deductible.
A practical checklist
- Define the measure being summed.
- Align category and amount records.
- Review exact and wildcard criteria.
- Test blanks, negatives and text values.
- Reconcile the matched rows independently.
Worked example
Illustrative example: synthetic Travel rows contain 12 and 8, while Software contains 5. SUMIF for Travel should return 20, not the count 2 and not the overall total 25. The reviewer traces both matching records before reporting the amount. No real client or financial information is required for this check.
Common questions
Does SUMIF count matching rows? It sums selected amounts. Is one criterion the same as several independent conditions? No. Does a matching expense automatically qualify for a deduction? No; that needs separate review.
What to do next
Keep a reporting definition with the formula. A trustworthy conditional total has an explicit measure, matching rule and independently checked example.
Sources and further reading
Related reading
- How to Offer Spreadsheet Cleanup as a Freelance Service
- Business Spending Tracker: Connect Every Entry to Evidence
Google Sheets FILTER Formula: Return Matching Rows Without Hiding the Source