COUNTIFS in Excel: Complete Guide with Examples | SheetXAI

The Problem

You need to count how many sales were made in the 'East' region AND were over $500. A single COUNTIF can only check one condition at a time.

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:

Count how many sales were in the 'East' region and over $500.

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.

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

Counts cells that meet multiple conditions. This is the multi-criteria version of COUNTIF.

Syntax: =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)

criteria_range1: The first range to evaluate against criteria1.
criteria1: The first condition that must be met (e.g., 'East', '>500', 'Active').
[criteria_range2, criteria2]: Additional range-condition pairs (optional, can add many).

Example: Count rows where Region is 'East' AND Revenue is '>500'.

You can add as many conditions as needed - all must be true for a row to be counted.

The Final Formula:

=COUNTIFS(A:A, "East", B:B, ">500")

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.