Excel Functions & Formulas
How to Sum in Excel If Cell Contains Text in Another Cell
Learn how to sum in Excel if a cell contains text from another cell using SUMIF, SUMIFS with wildcards, and the SUMPRODUCT function.
Read article
Sumif
10 lessons in order
Excel Functions & Formulas
How to Use SUMIF Across Multiple Sheets in Excel (2 Examples)
Learn how to use SUMIF across multiple sheets in Excel by combining SUM, SUMPRODUCT, and INDIRECT functions to sum data efficiently.
Read article
Excel Functions & Formulas
SUMIF with Multiple Criteria for Different Columns in Excel
Learn how to use SUMIF with multiple criteria for different columns in Excel using SUMIFS, combined conditions, matrix layout & SUMPRODUCT.
Read article
Excel Functions & Formulas
How to Sum If Greater Than and Less Than a Cell Value in Excel
Learn how to use SUMIF and SUMIFS in Excel to sum values greater than, less than, or between cell values using dynamic ranges & references.
Read article
Excel Functions & Formulas
How to Use SUMIF with Not Equal to Condition in Excel
Learn how to use SUMIF in Excel with a not equal to condition to exclude values, skip blanks, apply wildcards, and handle multiple criteria.
Read article
Excel Functions & Formulas
How to Use SUMIF Function to Sum by Cell Color in Excel
Learn how to use the SUMIF function to sum by cell color in Excel with GET.CELL, VBA code, and FILTER & SUBTOTAL alternatives.
Read article
Excel Functions & Formulas
Excel SUMIF Function to Sum Values Greater Than 0
Learn how to use the SUMIF function in Excel to sum values greater than 0 with formulas, cell references, and examples.
Read article
Excel Functions & Formulas
How to Use SUMIF Function to Sum Values Less Than 0 in Excel
Learn how to use the SUMIF and SUMIFS functions in Excel to quickly sum values less than 0 with formulas, examples, and tips.
Read article
Excel Functions & Formulas
How to Use SUMIF with Not Blank Criteria in Excel
Learn how to sum values in Excel only if cells are not blank using SUMIF, SUMIFS, SUMPRODUCT, FILTER, and helper column methods.
Read article
Excel Functions & Formulas
How to Sum If a Cell Contains Numbers in Excel
Learn how to sum cells containing numbers in Excel using VBA, Power Query, Regex, Flash Fill, and dynamic array formulas.
Read article