Formula:
="Total Pending = "&COUNTIF(Detail!C2:C7,"Pending")&": " &IF(COUNTIFS(Detail!C2:C7,"Pending",B2:B7,"1"),COUNTIFS(Detail!C2:C7,"Pending",B2:B7,"1")&" Team1","") &IF(COUNTIFS(Detail!C2:C7,"Pending",B2:B7,"2"),COUNTIFS(Detail!C2:C7,"Pending",B2:B7,"2")&" Team2","") &IF(COUNTIFS(Detail!C2:C7,"Pending",B2:B7,"3"),COUNTIFS(Detail!C2:C7,"Pending",B2:B7,"3")&" Team3","") &IF(COUNTIFS(Detail!C2:C7,"Pending",B2:B7,"4"),COUNTIFS(Detail!C2:C7,"Pending",B2:B7,"4")&" Team4","") &IF(COUNTIFS(Detail!C2:C7,"Pending",B2:B7,"5"),COUNTIFS(Detail!C2:C7,"Pending",B2:B7,"5")&" Team5","")
Bookmarks