Need assistance with the following COUNTIFS formula

Kristine Gagne, CSM, CSSGB

I am trying to count a status in one column (Last minute shipment set up) across MULTIPLE people in another column (Director). I created a working formula but it only tallies the status in one column across ONE person in another column:

=COUNTIFS([Director]:[Director], "john.smith@help.com", [Last minute shipment set up]:[Last minute shipment set up], "Missed scheduling shipment")

How can I modify this formula to add an additional person as criteria for Director?

Cheers,

Kristine

Jon Mark H

Hey @Kristine Gagne, CSM, CSSGB !

Does this solve the problem for you?:

=COUNTIFS([Director]:[Director], OR(@cell="john.smith@help.com", @cell= "INSERT ANOTHER NAME HERE"), [Last minute shipment set up]:[Last minute shipment set up], "Missed scheduling shipment")

If not, let me know & explain a little more - I'd love to try and help!

-Jon Mark

Jon Mark H

Hey @Kristine Gagne, CSM, CSSGB !

Does this solve the problem for you?:

=COUNTIFS([Director]:[Director], OR(@cell="john.smith@help.com", @cell= "INSERT ANOTHER NAME HERE"), [Last minute shipment set up]:[Last minute shipment set up], "Missed scheduling shipment")

If not, let me know & explain a little more - I'd love to try and help!

-Jon Mark

Kristine Gagne, CSM, CSSGB

Hi Jon -

This worked perfectly! I had tried something similar but had my parenthesis for the first range in the wrong spots. Thank you very much!

Cheers,

Kristine