Does Not Equal

katebrew

I have a formula that is working for me....the last part of the formula includes if the "Partner Driven" box is checked. 

I now want to run the formula if "Partner Driven" is unchecked - I think it includes <> but I can't figure out where to include the "does not equal.

=COUNTIFS([Event Date]:[Event Date], <=Today(), Theater:Theater, "Americas", [Partner Driven]:[Partner Driven], 1)

Paul Newcome

To reference an unchecked box, you simply replace the 1 with either 0 (zero) or false. To use the "not equal to" of <>, you would put it in the same placement as =.

 

This = That

 

This <> That