I could probably work this out eventually, but my head is spinning and
I know some of you like a challenge. It will form part of a Housing
Benefit calculation. There's a figure used in the benefit calculation
(unimportant here) which is based on the bedroom requirement of the
household. I want the bedroom requirement.

The worksheet will have the age of the single adult in C5, the age of
the partner (if they exist) in D5, the ages of the children in E5 to
I5 and the sex of the children (m or f) in E6 to I6.

Bedroom requirement:

Single adult: 1
Couple (same or different sexes): 1
Single or couple with 1 child: 2
Single or couple with 2 or more children: 1 for the adult(s) plus 1
for each pair of children if they're both under 10 and of either sex,
2 for each pair of children if either are over 10 and they're
different sexes, 2 for each pair of children if either is over 16 and
of either sex.