How to Use SUMIF in Google Sheets
SUMIF adds together values in a range that meet a specified condition. It is essential for budget tracking, expense reports, and financial analysis.
Understand the SUMIF Syntax
SUMIF(range, criterion, [sum_range]). The range is checked against the criterion, and matching cells in the sum_range are added together.
Sum Values Based on Text Match
Use =SUMIF(A1:A100, "Food", B1:B100) to sum all values in column B where column A contains "Food".
Sum Values with Numeric Criteria
Use =SUMIF(B1:B100, ">100") to sum all values greater than 100. The sum_range is optional when it is the same as the range.
Use SUMIF with Wildcards
Use =SUMIF(A1:A100, "*rent*", B1:B100) to sum values where the category contains "rent".
Try These Templates
Frequently Asked Questions
What is the difference between SUMIF and SUMIFS?
SUMIF handles one condition. SUMIFS handles multiple conditions and has a different argument order.
Can SUMIF add values from another sheet?
Yes. Reference another sheet like =SUMIF(Sheet2!A1:A100, "Criteria", Sheet2!B1:B100).