The Excel AVERAGEIF function calculates the average of numbers in a range that meet supplied criteria. AVERAGEIF criteria can include logical operators (>,,>,=) and wildcards (*,?) for partial matching.

AVERAGEIF in Excel – Example #1. The AVERAGEIF function in Excel calculates the average of cells that exactly match the criteria or the condition specified. Below you will see a table containing the product name and its units that are sold. In this exam

Although it is possible to type the AVERAGEIF function into a cell, many people find it easier to use the Function Dialog Box to add the function to a worksheet. Begin by entering the sample data provided into cells C1 to E11 of an empty Excel worksheet a