Good Afternoon,

I need to count the frequency of a speficic number within a list of values.

For Example:

A b
1 Vanessa 1
2 David 0
3 David 0
4 Silas 0
5 Marly 1
6 Vanessa 0
8 David 0
9 Marly 1
10 Silas 0
11 Silas 1
12 Marly 1
13 Vanessa 1

So I need a formula that will count the frequency of 1 on column b for
everytime column A equals Vanessa, David, Marly, Silas.

Results expected:

Vanessa 2
Marly 3
Silas 1
David 0

Thank you very much for your help.

Vanessa Simmonds