COUNTIFS with OR

Chris Hallo

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"))

Thank you!

Paul Newcome

One thing to keep in mind...

In your formula you typed out "Completed" (with a "d" on the end), but in the screenshot you provided, you have "Complete" (without the "d").

Paul Newcome

Try this...

=COUNTIFS([1-Ref]:[1-Ref], OR(@cell = "Completed", @cell = "Attestation"))

Chris Hallo

Thanks, Paul. It wasn't counting all so I went in another direction. I appreciate the prompt reply though.

Paul Newcome

One thing to keep in mind...

In your formula you typed out "Completed" (with a "d" on the end), but in the screenshot you provided, you have "Complete" (without the "d").

Chris Hallo

Paul, that would absolutely have accounted for the miscount. Thank you :).

Paul Newcome

Happy to help. Sorry I didn't catch that sooner.

Chris Hallo

That would be on me but I appreciate the second pair of eyes :).

Paul Newcome

Happy to help. 👍️