SUMIF()
Syntax. SUMIF(range,criteria,sum_range)
Definition. This function adds all values in a range that match the search criteria.
Arguments
range (required) The range in which you want to find the criteria.
criteria (required) The criteria in the form of a number, an expression, or text. The criteria determine which cells will be added. For example, the criteria argument can be expressed as 32, “>32”, “32”, or “apples”.
sum_range (optional) The actual cells to add.
Background. The SUMIF() function can be used to filter for certain values in a list and add those values. The values in an array are added only if they match the search criterion.
Excel provides additional functions that allow you to analyze data based on a condition. To count text or numbers ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
