Formula Question for multiple criterion


Good Morning,

I almost have this cracked:

=COUNTIFS({Emp Status}, [Emp Status]@row, {Rank}, "SGT", {G-300}, ="")

I want to add another Criterion after "SGT" so it can track SGT and LT, but I am coming up short.

This formula only works to see all SGTs who has taken G-300, but I want both SGT and LT.

Any suggestions?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!