CountIFS formula including OR

LouSnz
LouSnz
edited 12/09/19 in Formulas and Functions

Hello, I am trying to create a complex formula using ranges and inside the COUNTIFS i need to include OR functions, but when i do the below it comes up with error:

=COUNTIFS(OR({Current Jobs Completed Hour}, <7, {Current Jobs Completed Hour}, >18), OR({Current Jobs Created Hour}, <7, {Current Jobs Created Hour}, >18), {Current Jobs New Job or Other?}, <>"Direct Entry", {Current Jobs Current Month}, 1, {Current Jobs New Job or Other?}, <>"KIOSK", {Current Jobs Time}, <60)

 

Can anyone help with what i am doing wrong, or if there is no way you can include the OR inside a COUNTIFS?

Thanks!!!!!

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!