(Count if) And & Or

09/20/21
Accepted

I need a formula that will count the number of rows with High priority and are New OR Open. I cannot figure this out, so any help is appreciated!


Tags:

Best Answer

  • Dale MurphyDale Murphy ✭✭✭✭✭
    Accepted Answer

    @JKremer Here is my solution to a similar challenge:

    I find AND and OR tricky. In this case, instead of OR, I just add two similar CountIFS statements because I know they are exclusive.

    Make sense?

    Dale

Answers

  • Dale MurphyDale Murphy ✭✭✭✭✭
    Accepted Answer

    @JKremer Here is my solution to a similar challenge:

    I find AND and OR tricky. In this case, instead of OR, I just add two similar CountIFS statements because I know they are exclusive.

    Make sense?

    Dale

  • That worked beautifully! Thank you so very much 😀😁

Sign In or Register to comment.