| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
Put the limits in say E1:E5, and then enter this block array formula
=FREQUENCY(A1:A10,E1:E5) that is, select E1:E5, enter the formula in the formula bar, then commit with Ctrl-Shift-Enter. -- HTH RP (remove nothere from the email address if mailing direct) "SA UK" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula
Hi Bob Phillips
Thanks for your help. It worked! SA "Bob Phillips" wrote: Put the limits in say E1:E5, and then enter this block array formula =FREQUENCY(A1:A10,E1:E5) that is, select E1:E5, enter the formula in the formula bar, then commit with Ctrl-Shift-Enter. -- HTH RP (remove nothere from the email address if mailing direct) "SA UK" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula? | Excel Worksheet Functions | |||
| writing a formula for a colored value | New Users to Excel | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
