Using CountIfs to track a column will multiple options

Hi everyone I have a multi select column that I am trying to use a countifs statement to count of instances of a name. However it only returns cells where only the name exist and nothing else. Does anyone know how to make it that it counts all instances? Formula below for example

=COUNTIFS({Training Project Task List Range 3}, "Aubrey Campbell", {Late Check}, @cell = "Late")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!