try
=sumproduct((rngA=12345)*(rngD={"Adult","Veal"})*( rngF="Yes"))

"Gareth" wrote in message
...
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