Hello all,
I have recently started a new job in a large international school, and one of my responsibilities is to document and manage all the students who take placement tests. It was all going fine until I tried to filter the data on a separate worksheet and have now hit a wall. None of my colleagues have any knowledge. Help please!!
Basically I am collecting information like this :
ss1.jpg
Name, ***, score, level, group and time along the top. Level, group and time is the information I want to be passed through to my "summary" worksheet, which is here :
ss2.jpg
This sheet, called analytics, is designed to take the information from the first sheet and filter it accordingly. For example, if someone studies level B1 A, at 5:30-7:00 for Group A, and I input all this into the first sheet, I want the number in G12 to increase by 1, to 43 in this second sheet.
If I input another student studying A2 A at 4:00-5:30, Group B on the first sheet, I wish the number to increase by 1 on M9 in this second sheet.
At the moment I have manually counted and inputted all the numbers into the second analytics sheet! So the page you see - this is how I want it to look when the formulas are correct. I have tried, and failed many times to get this to work. I understand I may need to change some of the values in the first table - example using "Group A" and "Group B" rather than putting an "x" into 2 different columns.
Any help on how I can do this is appreciated
Thanks,
Fbis
Bookmarks