ƒx

Excel AVERAGEIF Formula

data Difficulty:

One-Click Copy

AVERAGEIF(range, criteria, [average_range])

Quick context

• Works in both Excel and Google Sheets.
• Use when you need consistent, auditable results.
• Copy the snippet above and adjust only the ranges.

When to use

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

Calculate the average of numbers that meet specific criteria.

Average with Condition

Calculate the average of numbers that meet specific criteria.

Inputs

range The range of cells to evaluate.
criteria The condition to match.
average_range Actual cells to average. If omitted, uses range.

Practical Example

=AVERAGEIF(B2:B25, ">10000")

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.