Back to Blog

AVERAGEIFS in Excel: Complete Guide with Examples | SheetXAI

D
David DeSouza
Dec 1, 2025
Flat design vector illustration of a calendar or project management grid being examined. A large light blue calendar with a darker blue header is centered, displaying a grid of white squares with several highlighted in soft yellow. A prominent magnifying glass with a light blue lens and dark red handle is positioned over the lower-left portion of the calendar. Stylized trees with rounded canopies in yellow and reddish-pink are visible on both sides, with abstract organic shapes in the background. The scene represents detailed analysis and calculating averages based on multiple conditions in a clean, modern aesthetic.

The Problem

You need to find the average sales, but only for the 'East' region AND only for products that are 'Active'. A single AVERAGEIF can only handle one condition.

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:

Calculate the average revenue for sales where region is 'East' and status is 'Active'.

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: AVERAGEIFS.

1. AVERAGEIFS

Calculates the average of cells that meet multiple conditions. This is the multi-criteria version of AVERAGEIF.

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

  • average_range: The range of cells to average (the actual values you want to average).
  • criteria_range1: The first range to evaluate against criteria1.
  • criteria1: The first condition that must be met (e.g., 'East', '>100', 'Active').
  • [criteria_range2, criteria2]: Additional range-condition pairs (optional, can add many).

Example: Average Revenue column where Region is 'East' AND Status is 'Active'.

Understanding the Logic

  1. Average range: The column with values to average (Revenue).
  2. First condition: Check Region column for 'East'.
  3. Second condition: Check Status column for 'Active'.
  4. Result: Only averages Revenue where BOTH conditions are true.

You can add as many conditions as needed - all must be true for a row to be included in the average.

The Final Formula:

=AVERAGEIFS(C:C, A:A, "East", B:B, "Active")

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