COUNTIFS with OR
Hello! Could I please get some help with this COUNTIFS? The intention is to count the rows where 1-Ref is either Complete or Attestation. I tried the below but it's currently returning UNPARSABLE.
=COUNTIFS([1-Ref]:[1-Ref], OR(([1-Ref]:[1-Ref] = "Completed", ([1-Ref]:[1-Ref] = "Attestation"))