Hi,

I am analysing data with male and female participants. Their gender data is in B2 down, classed as F (female) or M (male). The group can have up to 40 subjects in it but is variable in nature. In W2 down is their respective performance targets. I want to count

All females with a performance target of between -0.76 or less, 0 to -0.75 and those above 0.
All males with a performance target of between -0.76 or less, 0 to -0.75 and those above 0.

As the group can shrink and grow and there is data below this that could influence the accuracy of the count it needs to be dynamic in nature. There is always a space separating this and the next dataset below it.

Any help much appreciated.