Hi All
I am in need of some urgent help!
I am trying to use COUNTIF with two critera. If this isn't possible is there any other way possible of doing this in a range of cells
What I am trying to do is show the amount of students in a year group who spend x amount of hours on the internet and have a target grade (for example) of Lvl 4
I have been trying use a formula along the lines of =COUNTIF (Q5yr7, "0- 1Hour", Q12yr7, "4")
I will upload the spreadsheet when I get home as it will not allow me to do so at school
Many Thanks