COUNTIFS with OR

01/13/21
Accepted

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!

Best Answer

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

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

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Try this...

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

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

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

  • Paul NewcomePaul Newcome ✭✭✭✭✭

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

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

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

Sign In or Register to comment.