Thread: formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SA UK
 
Posts: n/a
Default formula

Hi

I have a list of exam results, in one column. I am trying to count how many
scored in 7 different ranges. I have tried the countif, frequency and sum
if, do not really know what I am doing wrong. I want to know how many
students scored between 0-39, then how many student scored between 40-49 then
how many scored between 50-59 etc. Can anyone help as I am now totally lost!

Thanks