Question

Locked

Excel: Count as a Percentage of Another Count?

By richard.greenberg ·
Math7-Smith-88
Math7-Smith-65
Math7-Smith-75
Math7-Smith-98
Math7-Smith-67
Tech7-Jones-77
Tech7-Jones-66
Tech7-Jones-45
Tech7-Jones-88
Tech7-Jones-75
Tech7-Jones-22
Tech7-Jones-77

Defined as: Course-Teacher-StudentScore

My report does not need to show who the students are, just the course and teacher and the following:

I need to report: What percentage of students in each Course received a score between (0-64, 65-74, 75-84, 85-100). So it looks like I need to Count1 = how many students in each course, then Count2 = how many students got scores within each range, and then use these 2 counts to report on what percentage count2 is of count1 in for each course. Any help with this would be most appreciated.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums