CountIfs and Find logic-Can I use together to get pending task counts for a particular Person

Rafsun Royal
Rafsun Royal ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I want to count Total number of Pending Task, Completed Task, Not Started  for each of my team members from a different sheet (Master Daily Tasks Update-IT Dev Range) to a new sheet


Currently I am using this one to count total number of Pending Task: =COUNTIFS({Master Daily Tasks Update-IT Dev Range 3}, "Harry Porter", {Master Daily Tasks Update-IT Dev Range 4}, "Pending Task")


Ok,  I am getting result for Harry Porter but there are some cells where I have multiple assignees and smartsheet is not counting those ones. 


HELP Please- Need the best Possible Solutions! 


Thanks in Advance!