First try to limit ranges everywhere - it quite often makes formula faster like:
Formula: copy to clipboard 
=IF(A15="","",IF((AND(COUNTIFS(J$1:J$10000,J15,AM$1:AM$10000,ABS(AM15),AD$1:AD$10000,AD15)>1, etc.


then think of splitting into smaller pieces and use helper column it seems, that you force excel to calculate the same sumproduct several times - may be calculate it only once in helper column - less elegant but more efficient :-)