Skip to content
- Excel SUMIF Starts With Text: Formula & ExamplesYes, you can use SUMIF to sum values where a corresponding text cell starts with specific characters, by using a wildcard asterisk…Formulas & functions
- Excel SUMIF Not Zero? Fix It With These 5 ChecksIf your Excel SUMIF formula returns 0 when it should return a number, the most common causes are mismatched criteria, text-formatted numbers,…Errors & fixes
- Excel SUMIF Left Text Range: How to FixThe direct answer: Excel’s SUMIF function cannot use a text range to the left of the criteria range. SUMIF only sums cells…Errors & fixes
- Excel SUMIF Not Working? 7 Fixes to TryIf your Excel SUMIF formula is not working, the most common causes are mismatched data types (text vs. number), using the wrong…Errors & fixes
- Excel SUMIF Includes Text? How It WorksYes, Excel’s SUMIF function can include text, but not as a value to add—text is used as a criterion to decide which…Formulas & functions
- Excel SUMIF by Month: Formula & ExamplesTo sum values by month in Excel, use SUMIFS with a helper column that extracts the month, or use SUMPRODUCT with the…Formulas & functions
- Excel SUMIF Ignore Errors: Formula & FixesThe direct answer: Excel’s SUMIF function does not have a built-in option to ignore errors, but you can make it ignore errors…Formulas & functions
- Excel SUMIF with Text: How to Sum Cells That Contain TextThe Excel SUMIF function can sum values based on a text criterion, such as a specific word, a partial match, or even…Formulas & functions
- Excel SUMIF Exclude Text: Formula & ExamplesTo exclude text in a SUMIF, use the criteria "<>*" (not equal to any text) or combine SUMIF with a wildcard. For…Formulas & functions
- Excel SUMIF Exact Text Match: Formula & FixesTo make Excel’s SUMIF match an exact text string (not a partial match), use the formula =SUMIF(range, "exact text", sum_range) with the…Formulas & functions
- Excel SUMIF Equals Text: Formula & ExamplesYes, you can use SUMIF with text criteria in Excel. The formula is =SUMIF(range, "text", sum_range) where the second argument is the…Formulas & functions
- Excel SUMIF Equal to Cell Value: How ToYes, you can use SUMIF with a cell reference as the criteria by simply typing the cell reference (like D1) directly into…Formulas & functions
- Excel SUMIF Equal to Cell: Formula & ExamplesYes, you can use SUMIF with a cell reference as the criteria by writing the formula as =SUMIF(range, A1, sum_range) — no…Formulas & functions
- Excel SUMIF Does Not Include? Hidden Gaps ExplainedExcel’s SUMIF function does not include cells that fail the criteria you specify, but more specifically, it does not include cells from…Formulas & functions
- Excel SUMIF Not Equal to Text: Formula & ExamplesYes, you can use SUMIF to sum cells where a corresponding text value is not equal to a specific text. The formula…Formulas & functions
- Excel SUMIF Does Not Contain Text: Formula GuideThe direct answer: Excel’s SUMIF function cannot directly sum cells that do not contain specific text because its criteria only support equality,…Formulas & functions
- Excel SUMIF Does Not Contain Text: Formula & ExamplesTo sum values in Excel where a corresponding cell does not contain specific text, use the SUMIF function with a wildcard and…Formulas & functions
- Excel SUMIF by Month: Formula & ExamplesYes, you can sum values in Excel by month using the SUMIFS function with two criteria: one for the first day of…Formulas & functions
- Excel SUMIF Contains Text From Another Cell?Yes, you can use the SUMIF function to sum values when a corresponding cell contains text from another cell by using wildcards…Formulas & functions
- Excel SUMIF Contains Partial Text: Formula & ExamplesYes, you can use SUMIF for partial text matches in Excel by combining it with wildcard characters. The formula is =SUMIF(range, "*text*",…Formulas & functions
- Excel SUMIF Contains Specific Text: Formula & ExamplesTo sum values in Excel when a cell contains specific text, use SUMIF with wildcards: =SUMIF(range,"*text*",sum_range). For example, =SUMIF(A2:A10,"*apple*",B2:B10) sums all amounts…Formulas & functions
- Excel SUMIF by Date: Formula & ExamplesTo sum values in Excel based on a date, use the SUMIF function with the date as the criteria, like =SUMIF(A2:A100, "2025-01-15",…Formulas & functions
- Excel SUMIF Based on Cell Value: Formula & ExamplesThe direct answer: use =SUMIF(range, criteria, [sum_range]), where range is the cells you check against a condition, criteria is the value or…Formulas & functions
- Excel Sum Returning Zero? Fix It FastIf your Excel SUM formula returns zero instead of the expected total, the most likely cause is that the cells contain text…Errors & fixes
- Excel Sum Showing Zero? Fixes That WorkIf your Excel SUM formula returns 0 when it should show a total, the cause is almost always that the cells contain…How-to basics
- Excel Sum Only Numbers Ignore Text in Cell?Yes, the SUM function in Excel automatically ignores text and blank cells within the range you give it. For example, =SUM(A1:A10) adds…How-to basics
- Excel SUM with INDEX MATCH for Multiple CriteriaThe direct answer: use SUM(INDEX(return_range, MATCH(1, (criteria1_range=criteria1) * (criteria2_range=criteria2), 0))) as an array formula (or with SUMPRODUCT for a non-array alternative). This…Formulas & functions
- Excel Sum Formula Not Updating? Fixes That WorkIf your Excel SUM formula is not updating, the most common cause is that calculation is set to Manual, so press F9…Formulas & functions
- Excel Sum If Not Zero: Formula & ExamplesTo sum only cells that are not zero in Excel, use the SUMIF function with the criteria "0". For example, =SUMIF(A1:A10,"0") adds…Formulas & functions
- Excel SUMIFS with Multiple Criteria (Examples)Use SUMIFS to sum values that meet multiple criteria: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...). For example, =SUMIFS(B2:B20, A2:A20, "North", C2:C20, ">100")…Formulas & functions