COUNTIFS function combined with array?

I have created a reporting database for competition results. I have successfully used the COUNTIFS function to provide reports based on several filtering criteria (i.e. number of gold medals, number of silver medals, number of bronze medals, number of medals at senior competition, number of medals at junior competition etc etc..). Having completed the excel training I am lookign to recreate tables using Pivot Tables

However, for each of the summary report figures I need to account for how many individuals are responsible for these (e.g. the report may show 10 gold medals but 5 athletes may have been responsible for these). This is something that I don't believe that a Pivot Table can calculate so I am looking to include some sort of worksheet function that will effectively count the number of unique name entries for each of the report filters applied.

I wrote a fairly complicated array that counts the number of unique name entries that appear in a column (where "name" refers to column B that contains names First_Last format.

The array formula is:
=SUM(IF(FREQUENCY(IF(LEN(Name)>0,MATCH(Name,Name,0),""), IF(LEN(Name)>0,MATCH(Name,Name,0),""))>0,1))-1

While this successfully gives me the number of unique names that appear, I have failed to combine this with the other COUNTIFS functions to calculate number of athletes responsible for each of the competition summary report fields.

Many thanks in advance!!