SUMIF

Definition: The SUMIF function in Excel is used to find the sum of a range of data that meets a specified criteria.

Syntax: ==SUMIF(range, criteria, [sum_range]).

Situation: This formula is appropriate in situations where you need to find the sum of a range of data that meets a specified criteria.

Example: If you have a range of data A1:A10 and you want to find the sum of the data that is greater than 5, you would use the formula =SUMIF(A1:A10, “>5”). This would return the sum of the data that is greater than 5.