Formula with OR Statement

AB

Good evening:

 

I am trying to add an OR to the formula below:

 

=COUNTIFS(Priority:Priority, ="P1", Status:Status, ="Potential")

Potential or Active

 

Thanks for your help in advance!

ChrisM68

Hi

 

Why don't you use countif and count the factors separately?

Just an idea...

Paul Newcome

=COUNTIFS(Priority:Priority, ="P1", Status:Status, OR(@cell = "Potential", @cell = "Active"))

 

You use the OR function in the Criteria section and use @cell references to make them logical statements for the OR.

 

The same can be done with AND statements which is especially useful when looking at date ranges.