View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ela ela is offline
external usenet poster
 
Posts: 16
Default 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