Google Sheets: How to count the number of times a certain value has been chosen

Hello,

As a fun project at my work I have been logging our standup sessions on who spoke 1st,2nd,3rd etc, and who they passed the "baton" to.

I've been doing this for a month now and would like to find a nice way to display this information.

I'm doing this in Google Sheets.


Example table

1st	2nd	3rd
Person X	Person Y	Person Z
Person Y	Person Z	Person X
Person Y	Person X	Person Z
Person Z	Person Y	Person X

What I want to be able to display is:

1) How many times each person was 1st,2nd,3rd etc. Example: Person X was 3rd 2 times.

2) How many times each person passed the "baton" on to another person. Example: Person X passed to Person Y 1 time. Person X passed to Person Z 1 time.

Here is one possibility, as modeled on Sheet3.
Make 2 lists of people, one in say column E and one, transpose, in F1:H1.
Use the following to count: =SUM(SUMPRODUCT(($A$2:$A$5=$E2)*($B$2:$B$5=F$1)),SUMPRODUCT(($B$2:$B$5=$E2)*($C$2:$C$5=F$1)))
I believe that you can apply this concept to Sheet1 using the list of names given on the People sheet.
Let us know if you have any questions.