COUNTIFS

Tahreem Tariq

Hi @Paul Newcome !

I hope you're doing well. I need help with a COUNTIFS Formula. I am trying to plug multiple criteria in an COUNTIFS statement but I'm just getting the value "0" and not the right value. The formula that I am using is:

=COUNTIFS(Status:Status, "Requested", Status:Status, "Demoed", [Automation Category]:[Automation Category], "Data Processing", [Automation Category]:[Automation Category], "Data Visualization", [Automation Category]:[Automation Category], "Robotics", [Automation Category]:[Automation Category], "Workflow")

Would you please be able to help me with this. I have seen many discussions and your responses are always accurate.

Thank you!

Paul Newcome

It looks like you want to count if status is "requested" OR "demoed" and the same for the different options within the [Automation Category] range. If that is the case, try this...

=COUNTIFS(Status:Status, OR(@cell = "Requested", @cell = "Demoed"), [Automation Category]:[Automation Category], OR(@cell = "Data Processing", @cell = "Data Visualization", @cell = "Robotics", @cell = "Workflow"))

Paul Newcome

It looks like you want to count if status is "requested" OR "demoed" and the same for the different options within the [Automation Category] range. If that is the case, try this...

=COUNTIFS(Status:Status, OR(@cell = "Requested", @cell = "Demoed"), [Automation Category]:[Automation Category], OR(@cell = "Data Processing", @cell = "Data Visualization", @cell = "Robotics", @cell = "Workflow"))

Tahreem Tariq

THANK YOU @Paul Newcome !!!!!

It works!!! Appreciate your help! :))

Have a great day!

Paul Newcome

Happy to help. 👍️

dave.mcpherson56751

Hi Paul

Just found the above and was also a perfect solution for what i was struggling with.

Thanks for posting

Dave