Forum Discussion
AverageIf Question --
I've tried the following Averageif formula- =AVERAGEIFS(E31:G31,I31:K31,M31:O31,Q31:S31,"<>""") to exclude zeros & blanks for non-contiguous range across the same row but different columns. Using t...
Why are you using non-contiguous ranges? Any non-numerical data (e.g. the +/- entries in D31, H31, L31, etc.) will be ignored by AVERAGEIF, so you can use simply:
=AVERAGEIF(E31:S31,"<>")
Regards