How to Use SUMIF in Google Sheets for Conditional Sums (Easy Guide)

Learn how to use SUMIF in Google Sheets for conditional sums. Step-by-step guide with syntax, examples, and tips to calculate data based on criteria easily.

Google Sheets SUMIF is one of the most useful formulas you can learn if you use spreadsheets to work with numbers. It lets you add values based on a certain condition, which makes it one of the most useful features for budgeting, reporting, tracking sales, and analyzing data.

What Is Google Sheets SUMIF?

Google Sheets SUMIF is a conditional formula that only adds values that meet a certain condition. In simple terms, it tells Google Sheets: 'Add these numbers, but only if they match this condition.'

• Add sales from one city
• Sum expenses in one category
• Total hours worked by one employee
• Calculate revenue from one product

Google Sheets SUMIF Syntax

• range → The cells you want to evaluate
• criterion → The condition that must be met
• sum_range → The cells to add if the condition is true

Simple Example of SUMIF

If you want to add up Laptop sales where column A has the product and column B has the sales amount:

Using SUMIF with Numbers

You can also use conditions based on numbers. For example, to add only values greater than 100:

Common Mistakes

• Mismatched range sizes
• Missing quotes for text criteria
• Extra spaces in data cells
• Numbers stored as text

Google Sheets SUMIF is more than just a formula—it's a useful tool for making your data clearer, more efficient, and easier to manage.