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.
Category: Math and trigonometry
Adds the cells specified by a given criteria
SUMIF(range, criteria, [sum_range])
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM