Use the AVERAGEIF function

Use the AVERAGEIF function to calculate the average of numbers in a range that meet given criteria. AVERAGEIF criteria can include logical operators (>,<,<>,=) and wildcards (*,?) for partial matching. 

=AVERAGEIF (range, criteria, [average_range])

• average_range is optional.

• The AVERAGEIF function can only apply a single condition. If you need to apply multiple criteria, use the AVERAGEIFS function.

For more info, see AVERAGEIF function.

Use the AVERAGEIF function to calculate the average of numbers in a range that meet given criteria. AVERAGEIF criteria can include logical operators (>,<,<>,=) and wildcards (*,?) for partial matching. 

=AVERAGEIF (range, criteria, [average_range])

• average_range is optional.

• The AVERAGEIF function can only apply a single condition. If you need to apply multiple criteria, use the AVERAGEIFS function.

For more info, see AVERAGEIF function.

Use the AVERAGEIF function to calculate the average of numbers in a range that meet given criteria. AVERAGEIF criteria can include logical operators (>,<,<>,=) and wildcards (*,?) for partial matching. 

=AVERAGEIF (range, criteria, [average_range])

• average_range is optional.

• The AVERAGEIF function can only apply a single condition. If you need to apply multiple criteria, use the AVERAGEIFS function.

For more info, see AVERAGEIF function.