Returns the average of values in a range that meet a given criterion.
=AVERAGEIF(C1:C10, ">50") averages only the numbers greater than 50 in C1:C10.