Hello, I need to find out how many specific values are in seperate columns. For example, Each row represents data from a participant. Values range from 1-3 and I want to find out how many 1's, how many 2's and how many 3's they reported. I know how to use the COUNTIF function, but it will take a long time because I have around 80 participants.
Solved by X. H. in 29 mins