Interpretation of formula in

Question

Hello ,

could you please suggest as to what '*" is interpreted in the formula below and if it makes any difference if we dont use the '*' :

=AVERAGEIF($B$11:$B$110,"*"&$N14&"*",$C$11:$C$110)

Answer

Above function is not working!!!

Try this

=SUMIF($B$11:$B$110,$N14,$C$11:$C$110)/COUNTIF($B$11:$B$110,$N14)

As alternative to Averageif(), To my knowledge there is no inbuilt function like "AVERAGEIF()"

You can use above formula in VBA macro to create Averageif() function.

Ariful