Counting status' only when certain criteria is present

Cayla Davis

We are trying to create a formula that will count if 'Update Required' or 'Ticket Opened' or 'New Document Submitted' is found and 'SBR' is found in another cell

Goal is for us to understand that from the SBR items, we have X amount of items pending

This is what we are using but i think it's counting things incorrectly

=COUNTIFS({UPDATE REQUIRED}, HAS(@cell, "Update Required")) + COUNTIFS({UPDATE REQUIRED}, HAS(@cell, "Ticket Opened")) + COUNTIFS({UPDATE REQUIRED}, HAS(@cell, "New Document Submitted")) + COUNTIFS({GDS}, HAS(@cell, "Sabre"))

Paul Newcome

You can use an OR to join multiple criteria sets for the same range. Are all of the ranges multi-select dropdowns? If not, you only need the HAS function for those ranges that are.

=COUNTIFS({Update Required}, OR(HAS(@cell, "Update Required"), HAS(@cell, "Ticket Opened"), HAS(@cell, "New Document Submitted")), {GDS}, HAS(@cell, "Sabre"))

Paul Newcome

You can use an OR to join multiple criteria sets for the same range. Are all of the ranges multi-select dropdowns? If not, you only need the HAS function for those ranges that are.

=COUNTIFS({Update Required}, OR(HAS(@cell, "Update Required"), HAS(@cell, "Ticket Opened"), HAS(@cell, "New Document Submitted")), {GDS}, HAS(@cell, "Sabre"))

Cayla Davis

Ah! you're a gem! Thank you Paul!

Paul Newcome

Happy to help. 👍️