Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.

The AVERAGEIFS function below calculates the average of all values in the range A1:A7 that are greater than or equal to 500 and less than or equal to 1000. Note: first argument is the range to …

Jun 8, 2025 · The Excel AVERAGEIFS function returns the average of cells that meet multiple conditions, referred to as criteria. To define criteria, AVERAGEIFS supports logical operators …

Jun 21, 2024 · Here, in this formula, the AVERAGEIF function will do the average of the Sales column because E5:E14 is the average range. Additionally, F5:F14 is the criteria range, and TRUE is the …

Jan 31, 2023 · When you are looking to average cells that meet a certain condition, AVERAGEIF is the function to use. The AVERAGEIF function is used to calculate an average of all cells in a given range …

Mar 6, 2025 · How to Use AVERAGEIF in Excel Excel's AVERAGEIF function allows you to calculate the mean of a dataset that has been filtered based on a single condition you set.

Aug 30, 2024 · Let’s tune in on how to use the AVERAGEIF function, step-by-step. Download the sample workbook here to tag along. That’s it – Now what? The AVERAGEIF function has three …

Open your dataset in Excel. Click on the cell where you want to display the result. In our example, this is cell G5. Press Enter. In the following dataset, we have a simple sales record that tracks different …

We will use the Excel AVERAGEIF function to calculate the average. Select cell F6, enter the formula =AVERAGEIF (B2:B7,F3), and press “ Enter.” The output is shown above. The function averages the …

What is the AVERAGEIF Function? The AVERAGEIF Function [1] is an Excel Statistical function, which calculates the average of a given range of cells by a specific criterion. Basically, AVERAGEIF …