Countifs Formulas

Good Morning,

I am trying to count if someone was promoted in 2020-2021 which has a Check box column or TRUE, as well as their rank. The formula is populating 0 so I must be doing something wrong? For instance we promoted 10 people to Associate Professor, 8 of which are female & 2 male.

=COUNTIFS({All Faculty List Range 3}, "true", {All Faculty List Range 4}, "Associate Professor")

Appreciate your help!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!