Hi I am a teacher (science) at a high school and we are trying to collect some data to very roughly traffic light students, meaning for the year 10s those that are going to have some serious issues with NCEA, moderate issues, and those that we aren't worried about, i.e. red, orange and green.
I have made a google doc where teachers can next to the students name can write 1 for red, 2 for orange and 3 for green and with conditional formatting it is working well.
The next step is to start extracting some information based on sex and ethnicity.
What I want to do is a count formula adding up the 1, 2, and 3 if the cell adjacent is a red, orange or green and the same for the ethnicity.
I have attached a google doc (names removed) or if someone can point me in the right direction as to what function I should be using.
Cheers
https://docs.google.com/spreadsheet/ccc?key=0AvjFV-K7Ke3zdGhvZnBUanhzSVFVTTZ4QUhBR3RkelE&usp=sharing