If the numbers are always either 1 or 0 as is shown in your sample data...

List the unique names in a range of cells.

E1:E4 = Vanessa, David, Marly, Silas

Enter this formula in F1 and copy down to F4:

=SUMIF(A$1:A$12,E1,B$1:B$12)

--
Biff
Microsoft Excel MVP


"Vanessa Simmonds" wrote in
message ...
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