My “AVERAGEIFS” is not working, returning #DIV/0!

[Liphor]

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.

[#2 · Accepted solution]

@Liphor 

Change in formula "=>" on ">="

AVERAGEIFS(Table2[MAC],Table2[YEAR / MONTH],">="&Sheet3!$F$2,Table2[YEAR / MONTH],"<="&Sheet3!$F$3).

[#3]

Thank you.