Excel's AVERAGEIF function allows you to calculate the mean of a dataset that has been ... For example, if someone's salary value was blank, it would be ignored in the average calculation.