COUNTIFS formula for two Ors and one separate?

Jenna2424

Hello,

I would like a formula that reads COUNTIF the RAID Item Type = PMO or RAID Item Type = Change Enablement or if the Program Display box is checked.

My formula currently works with the OR statement for the two RAID Item Types, but stops working when I try to add in the Program Display clause, as that is a separate column.

Any advice? Thank you!

dojones

Try this formula.

=COUNTIF([Raid Item Type]:[Raid Item Type], OR(@cell = "PMO", @cell = "Change Enablement"))