How can I count the number of Yes entries

[shakey775]

Hi all

I have come across a problem I am having difficulty solving

I have a sheet of raw data which contains duplicates on the next sheet I have removed duplicates and "vlookuped" the race type to corespond to the race number but i need to count the number of "yes" entries that corresponds to the race number not the race type

I have produced a basic version of the workbook as the original has over 50000 entries

Any pointers would be appreciated

Rgards Shakey

[Fluff13]

How about
=COUNTIFS(Table1[Race Number],[@[Race Number]],Table1[Did 5yo+ Run],"Yes")

[shakey775]

Hi Fluff 13
Fantastic it works on both the test and the real workbook thank you
I was nearly there but was referencing the wrong column
thanks once again
Brilliant

[Fluff13]

You're welcome & thanks for the feedback