If a criteria cell is empty, it is treated as a zero value (0).Zero values are included in the average.When calculating an average, empty cells, text values, and logical values TRUE and FALSE are ignored.To efficiently use the AVERAGEIF function in your worksheets, take notice of these key points:
To average cells with two or more criteria, use the AVERAGEIFS function.