Formula for counting task status by Sub team

Options

Hi, I want to calculate the number of 'Complete', 'In Progress' tasks by each sub team. The Sub Team column is a multiple value drop down. Need help with formula to calculate.

Thanks in advance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!