SUMIF(...)
How to sum values greater then a criteria.
Used Functions
Category: Math and trigonometry
Adds the cells specified by a given criteria
Syntax
SUMIF(range, criteria, [sum_range])
Practice SUMIF Formula at Sheetzoom
SUMIF formula at Microsoft help
0
We will use sumif with a logical operator to check for values greater then given values, and the respective values are summed to get the answer.