is it possible to shorten these type of queries and not change the outcome?
With Range("AE8") .Value2 = Application.CountIfs(Range("U:U"), "SC", Range("I:I"), "OPEN", Range("C:C"), "*MOC*", Range("P:P"), ">7", Range("F:F"), "*SYS GEN*", _ Range("Q:Q"), "DY", Range("J:J"), "<>X") + Application.CountIfs(Range("U:U"), "SC", Range("I:I"), "OPEN", Range("R:R"), "*MOC*", Range("P:P"), _ ">7", Range("F:F"), "*SYS GEN*", Range("C:C"), "<>*MOC*", Range("Q:Q"), "DY", Range("J:J"), "<>X")