Has anyone got any experiemce of using =favg function in excel and =fstd. I have been looking at a model that uses them. When I refresh I am getting #NAME?. I cannot find any information abou them at all.


{=FAVG(IF(Grup_White='Grup Averages'!$Q100,Grup_Blue))}

Grup_White and Grup_Blue are named ranges.