Assuming the unique names are listed in E1 down
In F1: =SUMPRODUCT((A$2:A$100=E1)*(B$2:B$100=1))
Copy down. Adapt ranges to suit your actual extents
Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Vanessa Simmonds" wrote:
I need to count the frequency of a specific 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