Excel formula for average based on criteria

Excel formula for average based on criteria

The AVERAGEIF function is one of the most useful functions since it enables Excel users to perform averages only on cells that meet the specified criteria. This function accepts a minimum of two parameters. However, you can choose to add the third parameter if you like. The compulsory parameters include Range and criteria. The range