Formula Question for multiple criterion

TimJL

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?

Paul Newcome

Try an OR statement like so:

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

TimJL

Perfect! Thanks!

Paul Newcome

Try an OR statement like so:

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

TimJL

Perfect! Thanks!

Paul Newcome

Happy to help. 👍️