Forum Discussion
Solved
Remove zeros from AVERAGEIF but causes too many arguments
Hi everyone. I am running a successful function: =AVERAGEIF(D3:D10000,"*"&J64&"*",F3:F10000) but I want to remove all 0 figures and they make the average lower than it should be as the 0 is som...
If you need multiple conditions, use AVERAGEIFS instead of AVERAGEIF. The order of the arguments is slightly different:
=AVERAGEIFS(F3:F10000, D3:D10000, "*"&J64&"*", F3:F10000, "<>0")
If you need multiple conditions, use AVERAGEIFS instead of AVERAGEIF. The order of the arguments is slightly different:
=AVERAGEIFS(F3:F10000, D3:D10000, "*"&J64&"*", F3:F10000, "<>0")