up vote 0 down vote favorite
share [g+] share [fb]

INPUT:

enter image description here

What is the format of the OUTPUT that we need:

enter image description here

OUTPUT for example INPUT:

enter image description here

So the problem is, I don't know how do I 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))

an ideas?

link|improve this question
62% accept rate
1  
use the COUNTIFS formula in Excel 2007. In prior versions, you will have to use an array formula – JMax Jan 11 at 10:56
It appears there are multiple values in some cells of column N. The formula is not going to be able to see them as separate values, therefore will not see 0,4 as 0 and 4. These need to be in there own rows/cells. – CharlieRB Jan 11 at 14:52
1  
Is that not continental notation for 3.4 ? Here in Spain the , and . are transposed. 1.000,2 is just over a thousand. – BrianA Jan 11 at 15:59
show 1 more comment
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.