Forum Discussion
AVERAGEIFS eliminate zeros DIV/0 error
I'm trying to average using multiple criteria now because it is taking into account the zeros if I just use AVERAGEIF (see screenshot where top formula was working, but including zeros). I tried an A...
If there are no data satisfying the conditions, it's not possible to calculate an average. You can use IFERROR for this:
=IFERROR(AVERAGEIFS($F$2:$F$42,$B$2:$B$42,"Tuesday",$F$2:$F$42,">0"), "")
Ah, yes. I wish Mac had the feature on Excel like Microsoft does where it goes step by step through the equation to show you how it is calculating each piece.
