Hi Chris,

Am Mon, 20 Jun 2016 20:54:04 +0100 schrieb chrisparker3268:

Simply if a box is checked and the score is three in any of those rows
(D5 and E5, D6 and E6, D7 and E7, and D8 and E8) then produce a 10 in D2
otherwise produce a 5. Conditionally formatting shows a check if D2
equals 10 and an X is it equals 5.

try in D2:
=IF(MAX((E5:E8=3)*(T5:T8=TRUE))=1,10,5)
and insert the array formula with CTRL+Shift+Enter


Regards
Claus B.
--
Windows10
Office 2016