Trying to count number of high priority when other column has not certain content

RobMartinez

Hi all,

trying to get a count for all 3-High priority for any row that has NOT the status of Resolved or Cancelled.

See screenshot below

Thanks for any help!!

Leibel S

@RobMartinez

this should work:

=COUNTIFS(Priority:Priority,@cell="3-High",Status:Status,NOT(OR(CONTAINS("Resolved",@cell),CONTAINS("Cancelled",@cell))))