You missing a delimiter:

Formula: copy to clipboard 
SUMPRODUCT(--(North!$D$2:$D$50000=B9),--(North!$R$2:$R$50000="One Man Crew"),--(NOT(North!$B$2:$B$50000="DDR")),--(North!$AQ$2:$AQ$50000))

Also, I wouls suggest you to keep range lower (if you don't have 50.000 rows to use... to 5.000, or how much you need)