I have the following columns:

Children's names, gender, SEN, EAL, FSM, PP and VA guide.

I'm trying to cross reference some of these with the VA guide (which is a score around the 100 mark. [I will basically be dealing with less than 100, 100 and greater than 100]).

So the problem I am having is that I am trying to count the EAL children (who are de-marked by 1 in the column) who get less than 100, 100 or more than 100.

EAL column is D

VA guide is M

and EAL are not sorted together as the children are sorted by children's names.