Multiple Countif

Hi all,

I am trying to count how many specific instances are happening within a year, for a particular dept, AND specific status. Below is what i have so far:

=COUNTIFS($Year$1:$Year$39, "2020", $Area$1:$Area$39, "Dept", ([Sub-Status]1:[Sub-Status]59, "Past Due")

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!