Count multiple criteria

I'm looking for a formula to count a single criteria from one cross sheet column and multiple criteria from another column. Any suggestions?

=COUNTIFS({My Sheet - Status}, "New Request"), {My Sheet - Unit}, OR(@cell = "Library", @cell = "MGEN", @cell="NuRes", @cell="OARS", @cell="ODEI", @cell="OTP", @cell="Registrar", @cell="UDS", @cell="Other")



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!