Forum Discussion
count how many time a value is in a column
I have list of names and a number near each name in a other column i want to know how many ppl i have from each number something like this 1 70 ppl 2 12 ppl 3 15 ppl any idea ?
hershel13 lets say you have names in A and categories in B and you want to count how many people are in each category you should be able to add col C with each category listed and in col D use:
=COUNTIF($B:$B,$C1)if you have a title in row 1 you may start in cell D2 and change that to $C2 before filling down