Track results by team

[sunnypalsingh326]

I have three columns with names. The first column contains members of team A, the second contains member of team B and the third contains the results. I want to count the number of winners from each team in the results column but I can't. Please help me.

 

[AlanY]

post a sample of data here

 

[sunnypalsingh326]

sorry for not doing so, but I figured out how in the following formula

=sumproduct(countifs(results,teama))

and it resulted in my desired outcome. The only help I need now is breaking down how the above formula works. Thanks.

 

[sunnypalsingh326]

bump.

I really want to know how countif nested in a sumproduct works. Please teach me.