---
title: "How to Use SUMIF in Excel: Syntax and Examples — Griddy"
description: "Learn Excel SUMIF syntax with examples for text, numbers, and cell references. Sum a matching column, use comparison operators, and know when to use SUMIFS."
canonical_url: "https://getgriddy.ai/blog/how-to-use-sumif-in-excel/"
---

[Blog](https://getgriddy.ai/blog/)/Excel

Excel

# How to Use SUMIF in Excel: Syntax and Examples

Learn Excel SUMIF syntax with examples for text, numbers, and cell references. Sum a matching column, use comparison operators, and know when to use SUMIFS.

Do this with AI

[Try Griddy free](https://app.getgriddy.ai/login?mode=register&next=%2F)

Start in your browser. Also works with Excel and Google Sheets.

[By Justin Freels](https://getgriddy.ai/about/)/Updated August 20, 2026/4 min read

SUMIF adds up all values in a range where a corresponding cell meets one condition. It's the go-to formula for "sum all sales from the West region" or "total all invoices over $500" — any time you need a conditional total from a single column.

## The syntax

fx

`=SUMIF(range, criteria, [sum_range])`

- **range** — the column you're checking the condition against
- **criteria** — the condition (a value, text, cell reference, or comparison like `">500"`)
- **\[sum\_range\]** — the column to add up. If omitted, Excel sums the `range` column itself

## Step-by-step example

You have sales data: Column A = Region, Column B = Revenue. You want total revenue from the "West" region.

**Step 1.** Click the cell where you want the total.

**Step 2.** Write the formula:

fx

`=SUMIF(A2:A100, "West", B2:B100)`

**Step 3.** To make it dynamic — pulling the region from a cell instead of hardcoding it:

fx

`=SUMIF(A2:A100, E2, B2:B100)`

Now change E2 to any region and the total updates automatically.

TIP

Use whole column references like `A:A` instead of `A2:A100` so the formula automatically includes new rows as data grows.

## Using comparison operators

Criteria can include operators wrapped in quotes:

fx

`=SUMIF(B2:B100, ">500", C2:C100)`

| Criteria example | What it matches |
| --- | --- |
| `"West"` | Exact text match |
| `">500"` | Numbers greater than 500 |
| `"<>"` | Non-blank cells |
| `"*Corp*"` | Text containing "Corp" |
| `">"&D2` | Greater than the value in D2 |

## SUMIF vs SUMIFS

SUMIF handles one condition. The moment you need two — West region _and_ revenue over $500 — use SUMIFS:

fx

`=SUMIFS(C2:C100, A2:A100, "West", B2:B100, ">500")`

SUMIFS also puts the sum range _first_, unlike SUMIF. It's a common source of confusion when switching between the two.

## The Griddy way

SUMIF is straightforward until you need partial text matches, date conditions, or OR logic — at which point the formula gets messy fast. Just describe what you need:

> "Sum all revenue where the customer name contains 'Corp' and the deal closed after January 1st"

Griddy writes the right formula for your exact column names and data structure.

## When SUMIF is the right tool

SUMIF is a good fit when one condition defines the total: one region, one owner, one status, or one threshold. Keep the criteria range and sum range aligned row-for-row. If you omit `sum_range`, Excel adds the cells in `range`, which is useful only when the condition and values live in the same column.

Use a cell reference for a changing criterion, such as `=SUMIF(B:B,H2,D:D)`, rather than embedding a label in every formula. For comparisons, put the operator inside a quoted string or concatenate it with a cell: `">="&H2`. Move to SUMIFS when the total needs two or more conditions. Before publishing the result, test a small known subset manually; a plausible total can still be wrong when categories contain trailing spaces or inconsistent labels.

## Sources

- [Microsoft Support: SUMIF function](https://support.microsoft.com/en-us/excel/functions/sumif-function)
- [Microsoft Support: Sum values based on one condition](https://support.microsoft.com/en-us/excel/sum-values-based-on-one-condition)

Do this with AI

## Turn the instructions into a finished spreadsheet.

Tell Griddy what you need in plain English, then inspect and keep editing the result in the browser, Excel, or Google Sheets.

[Try Griddy free](https://app.getgriddy.ai/login?mode=register&next=%2F)Start in your browser. No download required.

Also works with[Excel](https://appsource.microsoft.com/en-us/product/office/wa200008745)[Google Sheets](https://workspace.google.com/marketplace/app/griddy/206105793696)

Use this on real templates

## Use SUMIF in templates built for totals

SUMIF is a natural fit for budgets, expense logs, and operating plans where category-level totals and conditional rollups drive decisions.

[Finance](https://getgriddy.ai/templates/finance/)

[Finance ### Budget Tracker Track income, expenses, and savings in one place. Line items, budgeted vs actual totals, and monthly net savings — free to use in your browser. Open template](https://getgriddy.ai/templates/budget-tracker/)[Finance ### Freelancer Budget & Cash Plan Plan irregular client income, business expenses, tax reserves, owner pay, and cash buffer in one free freelancer budget spreadsheet. Open template](https://getgriddy.ai/templates/budget-tracker-for-freelancers/)[Finance ### Expense Tracker Log every expense, track receipts, and generate category summaries. Free template for personal or business use. Open template](https://getgriddy.ai/templates/expense-tracker/)[Finance ### Small Business Budget Plan revenue, direct costs, overhead, and EBITDA in one compact operating budget. Keep H1 totals, margin, and owner notes visible without building a giant finance model. Open template](https://getgriddy.ai/templates/small-business-budget/)

[All posts](https://getgriddy.ai/blog/)

Do this with AI

## Ask Griddy to do this for you.

Describe the result in plain English—no formula knowledge required.

[Try Griddy free](https://app.getgriddy.ai/login?mode=register&next=%2F)Start in your browser. No download required.

Also works with[Excel](https://appsource.microsoft.com/en-us/product/office/wa200008745)[Google Sheets](https://workspace.google.com/marketplace/app/griddy/206105793696)

About this guide

Written by Justin Freels, Founder, Griddy.

Updated August 20, 2026/4 min read

Related templates

[Finance](https://getgriddy.ai/templates/finance/)

[Budget Tracker](https://getgriddy.ai/templates/budget-tracker/)[Freelancer Budget & Cash Plan](https://getgriddy.ai/templates/budget-tracker-for-freelancers/)[Expense Tracker](https://getgriddy.ai/templates/expense-tracker/)[Small Business Budget](https://getgriddy.ai/templates/small-business-budget/)
