Adding metric to Count the number of tasks for an person when status is A or B.

ClanMcDe

I have a metric sheet with a team category that has 6 teams and I need a formula that will count the number of lines in another sheet that with a status of "In Progress" or "Not Started" that matches the team on the metric sheet.

Any help appreciated!

Zachary Ziegler

I would use a CountIF function for this one, and you'll want to use two separate CountIF functions to sum the total of the two statuses. Change the following formula to the name of the metric sheet you want to pull from but it should look like something similar to this:

=COUNTIF({Sheet B Range}, "In Progress") + COUNTIF({Sheet B Range}, "Not Started")