INPUT:

This is the format of the OUTPUT desired:

OUTPUT for example INPUT:

The problem is, I don't know how to use COUNTIF with several criteria.

The "dream function" [that doesn't work] would look like this in cell D3:

```
=(COUNTIF($M$2:$M$65535;boy) AND (COUNTIF($N$2:$N$65535;">0")-COUNTIF($N$2:$N$65535;">4")) AND (COUNTIF($O$2:$O$65535;WILMS))
```

Any ideas?

`COUNTIFS`

formula in Excel 2007. In prior versions, you will have to use an array formula – JMax Jan 11 '12 at 10:56