could you please suggest as to what '*" is interpreted in the formula below and if it makes any difference if we dont use the '*' :
Above function is not working!!!
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.