Interpretation of formula in

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:43 PM GMT

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

Advertisement

©2017 eLuminary LLC. All rights reserved.