I have the following problem and don't mind which solution is forthcoming:

Sheet1 contains data about claims made to our department (approx 700 rows).

Column A contains the claim reference number (5 digits) - there can be up to
50 rows with the same reference number.

Column D is either 'Adult' or 'Veal'.

Column F is either 'Yes' or 'No' to say if the animal is satisfactory.

What I need is the number of 'Adult' and 'Veal' claims that are
satisfactory. A satisfactory claim is defined as one where all animals in a
claim are 'Yes' in column F.

Thanks in advance.

Gareth