Hi, the data in my columns is:

B D O P

m/f ma score progress
m y 6 0
f 4 1
m p 6 -1
f mat 7 2
m 6 0
f 7 1

folrmula which brings over score (column O) is
=IF($N220,LOOKUP($N22,AR$20:$AR$62,AS$20:AS$62)," ")

I am trying to count how many boys have a test score and then sum the
progress for that group. Also to find out how many more able children have a
score and sum the progress for that group. I have got the formula to count
the boys who have test score and the more able who have a test score
=SUMPRODUCT(--(B21:B153<""),--(ISNUMBER(O21:O153))) but can't work out how
to sum the progress for them. I have spent ages trying to adapt formulae to
work!
Thanks
Mrs T