Iferror(sumproduct) count only when cell has a date

[mmccra2858]

Please refer to the attached file.
I'm trying to figure out a way to track the number of days that a work order was in queue, see archive column M, but only counting those work orders that had a due date (see archive column H)
On the tab Nov Stats column E row 5 I count the average lead time for closed orders which would be the average number of days in queue before closing the order, but I'm not sure how to get it to count only items that had a due date.

Thanks in advance for the help

[Jonmo1]

You just have to add a criteria (to both sumproducts in your formula)
--(Archive!H2:H4636>0)