countif or sumproduct

Originally Posted by cape

I have two conditions that exsist. in row a and row c. row a is a persons name and row c is either a 1 or a 0 (The 1 and 0 come from a formula in row c) Now i need to count how many times a persons name has a 1 next to it. Thanks in advance

=sumproduct((A1:A100="Person's name")*(C1:C100=1))

should work for you. You might just have to adjust the range 1:100 to fit your requirements.