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.
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