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