Help with sumif(1/(countif formula please!

[Galego]

I have two columns of data A and B. In column A i have duplicate values and in B 2 type of names (david and george). I would like to count the sum of umique values in colum A for David and then for George.

This is what i have so far.

=sum(1/(countif(a2:a200,a2:a200)

This one sums the unique values in column A but dont know how to add the second condition.

Thanks in advance.

 

[ExcelElliott]

Hi there, this link should help you

https://www.extendoffice.com/documents/excel/3403-excel-count-unique-based-on-another-column.html