Hi

I have the following formula that allows me to calculate the number of individual entries within a mass of data regardless of how many times an individual appears.

SUM(--(FREQUENCY(IF((County!$K:$K=D30),County!$D:$D),County!$D:$D)>0))

K = Year Group
D = ID

I am now wanting to add in additional criteria to calculate Ethnicity (R) in conjunction with the above.

Can anyone help please?

Cheers
M