Count a name once not multiple times

[Patriot2879]

Hi goodmorning, please can you help, I have a spreadsheet where it has peoplesnames and dates but for example there can be the same name on the same date inputtedmany times so Jo Bloggs on 1^st April could be listed 10 times, but Ionly want to count the name once and not 10 times please can you help with thisplease as the code below doesn’t work, it counts the name multiple times.

[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]=SUM(COUNTIFS('Activities-Complex'!C:C,"Jo Bloggs",'Activities-Complex'!AB:AB,D3)+SUM(COUNTIFS('Activities-Complex'!C:C,"JaneBloggs",'Activities-Complex'!AB:AB,D3)[/COLOR][/SIZE][/FONT]
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/CO[/COLOR][/SIZE][/FONT]DE]

 

[Patriot2879]

That is amazing, thank you works great, please can you advise how I can add other names to the list as well please, for example: Jo Bloggs, Jane Smith, John Doe, etc

 

[bobsan42]

Why don't you make a list of names along with a list of dates and take the the name the same way you take the date - refer to the cell with the name.
If you have jo Bloggs in E3 then use this:

=MIN(1,COUNTIFS('Activities-Complex'!C:C,E3,'Activities-Complex'!AB:AB,D3))

then you can fill all names in a column and use this formula for every name, rather than trying to put all names in one very long formula.
At the bottom of the column you can get the sum you need.

 

[Patriot2879]

That is a fantastic idea thank you so much for the help it works great

 

[bobsan42]

You are welcome