To solve this problem, you’ve got the option to use either theSUMIFS functionor theSUMIF function.
The SUMIF function is an older function that supports only a single condition.
SUMIFS on the other hand can be configured to apply multiple criteria.
Both options are explained below.
SUMIFS solution
In the example shown, the solution is based on the SUMIFS function.
Note that the SUMIFS function isnotcase-sensitive.
Also note that in the SUMIFS function,sum_rangealways comesfirst.
),see this page.
SUMIF solution
The SUMIF function is an older function in Excel that supports only a single condition.
Note that in the SUMIF function,sum_rangealways comeslast.
The result ($192) is the same as with the SUMIFS function above.
),see this page.
Whether you use SUMIFS or SUMIF is a matter of personal preference.
SUMIFS was introduced in Excel 2007, so it’s been around now for a long time.
Criteria can be applied to dates, numbers, and text.
Related videos
How to use the SUMIF function
How to use the SUMIFS function
