Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tallying student scores
I need to count the number of students who score in specific ranges on tests,
but also meet one other criteria, such as female. I have my spreadsheet set up so that the criteria (indicated by a single letter such as "f" for female) are in the first columns on the left, and the scores are entered in the columns on the right. So, I need to have the spreadsheet count the number of girls who scored below 60 (on a single test whose scores are in a single column), for example. I have a sumproduct formula that works for that, but I can't get a formula to work when I want to count the number of girls who scored between 61 and 70. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel golf scores, how do I add the scores for all par 3's etc | Excel Worksheet Functions | |||
Tallying | Excel Discussion (Misc queries) | |||
Tallying Lists | Excel Discussion (Misc queries) | |||
turning student scores into a level??? | Excel Worksheet Functions | |||
How do you use tallying in excel?? | Charts and Charting in Excel |