The formula matches the given criteria with the lookup range values and return only those that are less then the given criteria, the final sum is obtained by summing up these values.
How to sum values greater then a criteria.
Calculate sum based on given month with SUMIF
Count if less then a given criteria
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