Convert Formula to an Array formula

[L40]

I need help converting this formula into an array formula in order for my linked data to work.
=SUM(COUNTIFS('S:\Service\DOS\[Order.xlsm]2017_CURRENTMONTH'!$J:$J,">="&$C58,'S:\Service\DOS\[Order.xlsm]2017_CURRENTMONTH'!$J:$J,"<="&$F58,'S:\Service\DOS\[Order.xlsm]2017_CURRENTMONTH'!$L:$L,{"Yes"},'S:\Service\DOS\[Order.xlsm]2017_CURRENT MONTH'!$N:$N,{"ROBERT"}))

Can some one assist me with this. Thank you<o></o>

 

[RoryA]

Don't use full columns as it will slow down calculation a lot:

=SUMPRODUCT(('S:\Service\DOS\[Order.xlsm]2017_CURRENTMONTH'!$J$1:$J$1000>=$C58)*('S:\Service\DOS\[Order.xlsm]2017_CURRENTMONTH'!$J$1:$J$1000<=$F58)*('S:\Service\DOS\[Order.xlsm]2017_CURRENTMONTH'!$L$1:$L$1000="Yes")*('S:\Service\DOS\[Order.xlsm]2017_CURRENT MONTH'!$N$1:$N$1000="ROBERT"))

You can change the 1000 as necessary but make sure all the ranges use the same number of rows.

 

[L40]

Thank you for the feed back but it is not working. I'm getting an error saying the formula contains an error.