counting by group
 

For the following data,

decision Base <50 50-60 60-70 70
FN 20.632 1 0 0 0
FN 34.492 1 0 0 0
FN 37.398 1 0 0 0
FP 65.422 0 0 1 0
FP 161.897 0 0 0 1
FP 102.764 0 0 0 1
FP 90.76 0 0 0 1
FN 10.738 1 0 0 0
FP 151.7 0 0 0 1


is there any quick way that i can ask excel to derive the statistics just
below?

decision <50 50-60 60-70 70
FN 4 0 0 0
FP 0 0 1 4

counting by group
 

Assuming the results table is in L1:Pn, in M2 enter

=SUMIF($A:$A,$L2,C:C)

and copy across and down.

--
__________________________________
HTH

Bob

"ela" wrote in message
...
For the following data,

decision Base <50 50-60 60-70 70
FN 20.632 1 0 0 0
FN 34.492 1 0 0 0
FN 37.398 1 0 0 0
FP 65.422 0 0 1 0
FP 161.897 0 0 0 1
FP 102.764 0 0 0 1
FP 90.76 0 0 0 1
FN 10.738 1 0 0 0
FP 151.7 0 0 0 1


is there any quick way that i can ask excel to derive the statistics just
below?

decision <50 50-60 60-70 70
FN 4 0 0 0
FP 0 0 1 4

counting by group
 

"Bob Phillips" wrote in message
...
Assuming the results table is in L1:Pn, in M2 enter

=SUMIF($A:$A,$L2,C:C)

and copy across and down.

--
__________________________________
HTH

Bob


it seems you are using array formula...?

What's Pn?
and $L2 are the condition criteria, what are they...?

counting by group
 

No, it is not an array formula, just a standard formula.

Pn is column P, down to some indeterminate row, n, that only you know.

$L2 is the decision value being tested, FN in row 2, FOP in row 3, etc.

--
__________________________________
HTH

Bob

"ela" wrote in message
...

"Bob Phillips" wrote in message
...
Assuming the results table is in L1:Pn, in M2 enter

=SUMIF($A:$A,$L2,C:C)

and copy across and down.

--
__________________________________
HTH

Bob


it seems you are using array formula...?

What's Pn?
and $L2 are the condition criteria, what are they...?