Table of Contents
About
SUMIF function is used to find the sum of cells satisfying a specific condition.
Function Type
Math and trigonometry
Purpose
Get the sum of cells satisfying a specific criteria
Return value
A number equivalent to the sum of cells satisfying the specified condition
Syntax
=SUMIF(range,criteria,[sum_range])
Arguments
range – The range of cells to evaluate the criteria
criteria – The condition to check or the criterion to evaluate
sum_range – [optional] range of cells containing values to add. If sum_range is not specified, the corresponding values in range will be added.
Example 1
Notes
SUMIF function supports wildcards
To check multiple criteria, use SUMIFS function.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)