Home › Excel formulas › Math and Trig › SUMIF

SUMIF Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

SUMIF is an Excel Math & Trig function. Adds up numbers, but only the ones that meet a condition.

SUMIF syntax

=SUMIF(range, criteria, [sum_range])

Arguments

range: The range of cells to check
criteria: The range containing the conditions to apply
sum_range: The range to sum, if different from the range being checked (optional)

When to use SUMIF

SUMIF is used in financial models and engineering-style calculations where precise numeric work is needed.

Practice SUMIF online, free

Open the live Excel-style spreadsheet and try SUMIF yourself. No Excel install or sign-up needed to start.

Practice SUMIF now →

Watch: SUMIF in Excel

Watch on YouTube

Learn more

Read the tutorial: How to use SUMIF.

SUMIF practice questions

Using SUMIF, find the total sales for the North region and put it in E2.

More Math & Trig functions

Frequently asked questions

What does the SUMIF function do in Excel?

Adds up numbers, but only the ones that meet a condition.

What is the syntax of SUMIF in Excel?

The syntax is =SUMIF(range, criteria, [sum_range]). range: The range of cells to check; criteria: The range containing the conditions to apply; sum_range: The range to sum, if different from the range being checked (optional).

Where can I practice SUMIF online for free?

Open the free live spreadsheet on Cellgrids and try SUMIF yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts