Excel SUMIF Function
excel-sumif• Pick a category and watch SUMIF add only the amounts that match the condition. • Learn the criteria range, criteria and sum range by example.
💡 Change the category and the total recalculates automatically. It works the same in the downloaded Excel file.
How to read SUMIF
Find the rows in the criteria range that equal the criteria, then add up only their values in the sum range.
If you omit the sum range, the criteria range itself is summed. Criteria can be text, a number, or a comparison (＞, ＜, ＜＞).
Worth knowing alongside SUMIF
SUMIF adds up only the rows that meet a condition. You can total exactly what you need without splitting the table or applying a filter, which makes it a staple for totals by category or by person.
The criteria can be more than plain text or a number. ">1000" adds only values above 1000, and "<>Fruit" adds everything that is not Fruit. An asterisk acts as a wildcard, so "App*" catches anything starting with App.
For two or more conditions use SUMIFS. The one thing to watch is that its arguments run in the opposite order — the sum range comes first. The same idea gives you COUNTIF for counting and AVERAGEIF for averages.