Hi,
Going round in circles trying to create a Report which will count all boys ("M") who have a support date in the T1 column shown - under column T1 result should be 1 for boys and 2 for girls. Ive tried various =Count and nested Iif functions but simply cannot get my head around it. Any help much appreciated.
Many thanks in anticipation.