Please help!!!

[Gareth]

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

 

[Patrick Molloy]

Please use the subject to give anm indication of the
question. "Please Help" is just meaningless.

there are several variations that you could use.
For example you could use the following ARRAY formula#

{=SUM((B5:B105="veal")*(C5:C105="Yes"))}

Patrick Molloy
Microsoft Excel MVP

 

[Gareth]

Apologies for not entering a meaningful subject, I
couldn't think of one.

Your formula counts the number of satisafactory records
for both veal and adult, but I want to count the number of
satisfactory claims.

Gareth