Jul 09 2020 12:41 PM
something like this
1 70 ppl
2 12 ppl
3 15 ppl
any idea ?
Jul 09 2020 12:57 PM
@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
Jul 09 2020 02:06 PM
Please clarify you would like to count or to sum. For example, name ABC has two records
ABC 70 ppl
ABC 20 ppl
result shall be 2 or 90 ppl?
Jul 09 2020 02:23 PM
name | Rate |
name a | 1 |
name b | 1 |
name c | 1 |
name d | 1 |
name e | 2 |
name f | 2 |
I want to know how many ppl I have rate 1 how many 2 total numbers
Rate | Total |
1 | 4 |
2 | 2 |
=
Jul 09 2020 03:27 PM
@hershel13 you build a pivot table that groups by rate, and counts instead of sum (you select the formula to use for grouping).
Jul 09 2020 04:36 PM
As variant for
formula is
=CHOOSE({1,2},UNIQUE($C$3:$C$8),COUNTIF($C$3:$C$8,UNIQUE($C$3:$C$8)))