Articles with the tag:
Articles with the tag:
Try in the cloud
Try in the cloud

SUMIF Function

The SUMIF function is one of the math and trigonometry functions. It is used to add all the numbers in the selected range of cells based on the specified criterion and return the result.


SUMIF(range, criteria, [sum_range])

The SUMIF function has the following arguments:

Argument Description
range The selected range of cells to apply the criterion to.
criteria The criterion used to determine the cells to sum, a value entered manually or included into the cell you make reference to.
sum_range The range of cells to sum. It is an optional argument, if omitted, the function will sum the numbers of range.


You can use wildcard characters when specifying criteria. The question mark "?" can replace any single character and the asterisk "*" can be used instead of any number of characters.

How to apply the SUMIF function.


The figure below displays the result returned by the SUMIF function.

sumif function gif

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action