I've got the following formula
=COUNTIFS(MachineData!N:N,{"*Arlington*","*RenewNorfolk*"}, MachineData!$X:$X,"Y",MachineData!$E:$E,"<>*rinse*", MachineData!$C:$C,">="&$O$15-30, MachineData!C:C,"<="&$O$15+0.999988)
On the very first part of the formula I am trying to say "Count if MachineData!N:N is either like Arlington or like RenewNorfolk" but for some reason that specific part of the formula is giving me problems. Can someone help me figure out what the issue is with my syntax? Thank you