May 15 2021 06:28 AM
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.
May 15 2021 06:51 AM
SolutionChange in formula "=>" on ">="
AVERAGEIFS(Table2[MAC],Table2[YEAR / MONTH],">="&Sheet3!$F$2,Table2[YEAR / MONTH],"<="&Sheet3!$F$3).
May 15 2021 06:51 AM
SolutionChange in formula "=>" on ">="
AVERAGEIFS(Table2[MAC],Table2[YEAR / MONTH],">="&Sheet3!$F$2,Table2[YEAR / MONTH],"<="&Sheet3!$F$3).