Formula for counting task status by Sub team

SoumyaD

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!

Paul Newcome

You are going to want something like this...

=COUNTIFS(Status:Status, @cell = "Complete", SubTeam:SubTeam, HAS(@cell, "Team A"))