Multiple SUMIFS formula

[gohawks222]

Does anyone see a problem with this formula? Values in E2 and F2 are dates, and using those dates as criteria it should sum the values. It's returning zero right now when it should be returning a value.

=IFERROR(((ABS(((SUMIFS(Orders!$B2:$BJ2, Orders!$B$1:$BJ$1, ">="&$E$2, Orders!$B$1:$BJ$1, "<"&$F$2))-(SUMIFS(Forecast!$B2:$BJ2, Forecast!$B$1:$BJ$1, ">="&$E$2, Forecast!$B$1:$BJ$1, "<="&$F$2)))/(SUMIFS(Orders!$B2:$BJ2, Orders!$B$1:$BJ$1, ">="&$E$2, Orders!$B$1:$BJ$1, "<"&$F$2))))*((SUMIFS(Orders!$B2:$BJ2, Orders!$B$1:$BJ$1, ">="&$E$2, Orders!$B$1:$BJ$1, "<"&$F$2))))/((SUMIFS(Orders!$B2:$BJ2, Orders!$B$1:$BJ$1, ">="&$E$2, Orders!$B$1:$BJ$1, "<"&$F$2))),0)

 

[Stubble Kid]

Check to ensure all your dates are setup as date values and not as text, as this could be a reason for the formula being confused.

Try adding zero to all your references of E2 and F2 in the formula so that Excel explicitly converts them to date values e.g. SUMIFS(Orders!$B2:$BJ2, Orders!$B$1:$BJ$1, ">="&$E$2+0, Orders!$B$1:$BJ$1, "<"&$F$2+0)

This will certainly help if any cells in the criteria range are blank.

If you take out the IFERROR wrapper does the formula just return the value zero, or some error value such as #VALUE, or #DIV/0?