OR in COUNTIFS Formula

Helllo Community,

I am struggling to figure out this COUNTIFS formula with OR included. I am trying to count the amount of cells on a separate sheet that have the same part number and their status is either "Repaired" or "Beyond Repair". I will paste my current formula below, and it is outputting invalid operation. Any help here is appreciated!

=COUNTIFS({part 1 #}, [Part Number]@row, OR({status} = "Repaired", {status} = "Beyond Repair"))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!