I have 'claim ref' in column A, 'type of claim' in column
C and 'satisfactory' in column E.

There will be 30 or so records with the same claim ref,
the type of claim will be either 'adult' or 'veal'
and 'satisfactory' will be Yes or No. There can be up to
15 claims on a sheet.

How can I count the number of satisfactory adult claims
and the number of satisfactory veal claims?

A claim is only satisfactory if all records with the same
claim ref are 'Yes'.

My head hurt's thinking about this one, I'm sure there
must be an easy answer.

Thanks in advance.

Gareth