Forum Discussion
My “AVERAGEIFS” is not working, returning #DIV/0!
I am trying to find the averageifs for different months with different duration as shown in my attach worksheet. However I keep getting #DIV/0!. Example of my typical equation is AVERAGEIFS(Table2[MAC],Table2[YEAR / MONTH],"=>"&Sheet3!$F$2,Table2[YEAR / MONTH],"<="&Sheet3!$F$3).
I am not able to find the error and appreciate for help on this matter.
Change in formula "=>" on ">="
AVERAGEIFS(Table2[MAC],Table2[YEAR / MONTH],">="&Sheet3!$F$2,Table2[YEAR / MONTH],"<="&Sheet3!$F$3).
Change in formula "=>" on ">="
AVERAGEIFS(Table2[MAC],Table2[YEAR / MONTH],">="&Sheet3!$F$2,Table2[YEAR / MONTH],"<="&Sheet3!$F$3).
- Thank you.
