I am trying to create a formula for this scoring sheet.

If any of D 5 6 7 8 contain a 1 = 1

If any of D 13 14 15 16 contain a 1 = 1

If any of D 20 21 22 23 contain a 1 = 1

If any of D 27 28 29 30 contain a 1 = 1

Thanks
N

MCAA Part A scoring.xls