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

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" <(E-Mail Removed)> wrote in message
news:gggo9e$lfr$(E-Mail Removed)...
> 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
>
>

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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...?

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" <(E-Mail Removed)> wrote in message
news:gggv4l$ol9$(E-Mail Removed)...
>
> "Bob Phillips" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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...?
>