1

INPUT:

enter image description here

This is the format of the OUTPUT desired:

enter image description here

OUTPUT for example INPUT:

enter image description here

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?

6
  • 1
    use the COUNTIFS formula in Excel 2007. In prior versions, you will have to use an array formula
    – JMax
    Jan 11, 2012 at 10:56
  • yogeshguptaonline.com/2009/10/… Jan 11, 2012 at 11:53
  • 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, 2012 at 14:52
  • 2
    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, 2012 at 15:59

1 Answer 1

1

Add a column that classifies by range (say P2=IF(N2>=9,"R4",IF(N2>4,"R3",IF(N2>1,"R2","R1"))) & copy down) then use a pivot table. With some appearance modification (and using Excel 2007) the result seems close enough to serve:

Pivot table example

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .