AVERAGEIF

Google-Sheets

Definition

Returns the average of values in a range that meet a given criterion.

Example

=AVERAGEIF(C1:C10, ">50") averages only the numbers greater than 50 in C1:C10.

Stop Juggling Dashboards. Start Growing Get your data flowing today, free plan available.