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...
Hello,
You can read the article below to have a better understanding of how AVERAGEIFS function works with example..
Cheers
You can read the article below to have a better understanding of how AVERAGEIFS function works with example..
Cheers