CODEWITHSUNDEEP
google-sheets
Any G
Any G

Reputation: 11

Count number of occurences in columns and output as chart

I'm coaching a little league team and would like to keep track of how many times a player has played a certain position in a game. I have a table with the available positions as column headers and enter the name of the player who played at that position after each game.

Here is an image of the table:

enter image description here

I'd like to output a chart or table where I can easily see how many times the players have played in the various positions.

How would I do this most efficiently?

Upvotes: 1

Views: 100

Answers (1)

pnuts
pnuts

Reputation: 59485

Add a column on the left below your existing table, list all players names there (one row each) then use a COUNTIF formula (under Pos A and copied across and down), eg:

=countif(B$2:B$3,$A5)

Table example

Upvotes: 1

Related Questions