View Single Post
  #1   Report Post  
Pro_D Mike
 
Posts: n/a
Default Count a value if next to another value...

I'm entering data in a chart, and want to pull stats off that chart. Most
entries are text, but two columns contain types and codes. Lets say the set
of types is A,B,C, etc.., and the set of codes is 1,2,3, etc... I want to
count to get percentages of rows containing type A that are code 1 over all
rows containing type A; rows containing type A that are code 2 over all rows
containing type A, etc. for type B and C; also rows containing code 1 over
all rows, etc. for code 2, code 3; Little help?