COUNTIFS And OR
The formula below works, but I have a situation where I want to count when two different attorneys are listed in the Attorney field.
=COUNTIFS(Attorney:Attorney, ="Attorney1", [Contract Status]:[Contract Status], OR(@cell = "Customer Legal Review", @cell = "Pending PAC", @cell = "Pending SRTC", @cell = "Sent for Signatures", @cell = "WD Legal Review", @cell = "Waiting for Requestor Response"))
Can someone please assist? Thank you.
Help Article Resources
Check out the Formula Handbook template!