Back to Blog

How to Use SUMIF in Excel

D
David DeSouza
Dec 1, 2025
A flat design illustration in earth tones, depicting a dark gray spreadsheet-like interface with a header bar showing three white circles (minimize, maximize, close) and a larger sheet below. The sheet has a grid of cells, with some horizontally arranged cells shaded in a peach color, suggesting populated data. On the left, two stacks of peach-colored coins are seen, with dark purple leaves behind them. On the right, a stack of books with peach-colored covers rests below a similar plant. Two peach-colored circles with two vertical white lines inside (resembling a pause symbol) are positioned on the upper left and upper right of the spreadsheet. Abstract organic shapes in light peach and beige form a background. The color palette primarily includes dark gray, various shades of peach, beige, white, and dark purple.

The Problem

You don't want the total revenue; you want the total revenue specifically for the "East" region.

The Easy Way: Use SheetXAI

If you don't want to mess with formulas, the fastest way to do this is simply by asking.

With SheetXAI, you can open the sidebar and type:

Sum the total revenue for the 'East' region.

SheetXAI will instantly write the formula or script for you and fill the cells. It handles the syntax so you can focus on the result.

The Manual Way: The Formulas You Need

To do this manually, you need to use: SUMIF.

1. SUMIF

Adds the cells specified by a given condition.

Syntax: =SUMIF(range, criteria, [sum_range])

  • range: The range of cells you want evaluated.
  • criteria: The condition that defines which cells will be added.
  • sum_range: The actual cells to add, if you want to add cells other than those specified in the range argument.

Example: Check Region Col, look for "East", sum Revenue Col.

Understanding the Logic

  1. Check the Region column for "East".
  2. If it matches, add the corresponding number from the Revenue column.

The Final Formula:

=SUMIF(A:A, "East", B:B)

Conclusion

Now you know the "classic" way to solve this using formulas. It's a great skill to have.

But for those times when you just want the job done without the mental math, SheetXAI is there to help.

Read Next

An illustration of a rectangular browser window displaying a spreadsheet-like grid with cells containing bright blue horizontal bars. A red callout box with black text that reads "Company.com" points to one of the cells. A large magnifying glass, with a grey lens and a dark gray handle with a red accent, is positioned over the right side of the grid, enlarging the cells beneath it. The browser window has three circular buttons (red, blue, white) on its top left. Minimalist abstract shapes, including lines and circles in dark gray, surround the main illustration on a white background. The overall color palette includes dark purple, red, light blue, and white.

How to Extract Domains from Emails in Excel (Without Formulas)

Extract domains from emails in Excel without complex formulas! Learn the easy, no-formula method and a powerful tool to clean your data fast. Get company.com from john@company.com effortlessly.

An illustration of a rectangular browser window displaying a spreadsheet-like grid with cells containing bright blue horizontal bars. A red callout box with black text that reads "Company.com" points to one of the cells. A large magnifying glass, with a grey lens and a dark gray handle with a red accent, is positioned over the right side of the grid, enlarging the cells beneath it. The browser window has three circular buttons (red, blue, white) on its top left. Minimalist abstract shapes, including lines and circles in dark gray, surround the main illustration on a white background. The overall color palette includes dark purple, red, light blue, and white.

How to Extract Domains from Emails in Google Sheets (Without Formulas)

Extract domains from emails in Google Sheets effortlessly! Discover how to do it without formulas using AI, or master the LEN, SEARCH, and RIGHT functions for precise extraction.

Illustration for How to Separate First and Last Names in Excel

How to Separate First and Last Names in Excel

Separate first & last names in Excel! Learn manual formulas (LEFT, RIGHT, SEARCH) or instantly split names with SheetXAI. Save time & get accurate results fast.

Boost your productivity today.
Start automating your spreadsheets.

Join thousands of professionals saving hours every week. No credit card required to start.

Learn more