Excel SUMIF with Multiple Criteria Same Column
Adding values for several statuses in the same column is awkward if you run separate SUMIF formulas by hand. You can handle it with an array of allowed criteria and one combined formula. This guide shows how to sum two matching labels from one status column without duplicating your work.
Formula Syntax
Use this base syntax for excel sumif with multiple criteria same column and replace the ranges with your own spreadsheet columns.
SUM(SUMIF(range, criteria_array, sum_range))Need this formula for your exact sheet?
Generate a custom excel sumif with multiple criteria same column formula with your own columns, criteria, and spreadsheet layout.
Step-by-step Example
A support reporting spreadsheet tracks Support ticket totals and needs a formula-driven result instead of manual filtering.
| Status | Hours |
|---|---|
| Open | 3 |
| Pending | 2 |
| Closed | 5 |
Resulting formula
=SUM(SUMIF(A:A,{"Open","Pending"},B:B))The formula evaluates the Support ticket totals rows and returns 5. Replace the sample ranges with your actual columns, then adjust the criteria so the result matches your workbook.
Try It Now
The generator is pre-filled for excel sumif with multiple criteria same column. Edit the prompt to match your columns, criteria, and spreadsheet layout.
Generated formula
How it works
Need more formulas every day?
HelpFormula Pro is $7.99/mo for faster spreadsheet work across Excel and Google Sheets.
- ✓ Higher daily formula generation limits
- ✓ Saved formula history for reuse
- ✓ Excel formula language selection
Common Variations
- Use SUMIFS for AND logic
- Use an array constant for OR logic
- Match several text labels
FAQ
How do I set up Excel SUMIF with Multiple Criteria Same Column for Support ticket totals?
Map the sample columns to your own sheet first, then replace the formula ranges with the real ranges from your workbook. Keep text criteria in quotes and verify that date or number columns are stored as real values.
Can this formula handle use SUMIFS for AND logic?
Yes. Use the same formula pattern and change the criteria, helper column, or lookup value for use SUMIFS for AND logic. If the logic becomes more complex, generate a custom version with the free tool.
What should I check if the Excel SUMIF with Multiple Criteria Same Column result is wrong?
Check that every referenced range covers the same rows, locked references use dollar signs where needed, and the criteria type matches the data. For this page, also confirm that the Support ticket totals fields are formatted consistently.