Thx Joffm,
I managed to get the validation to work by totalling the cells in each column i.e.
sum(Q10a_SQ021_SQ031, Q10a_SQ022_SQ031, Q10a_SQ023_SQ031, Q10a_SQ024_SQ031, Q10a_SQ025_SQ031, Q10a_SQ026_SQ031, Q10a_SQ027_SQ031, Q10a_SQ021_SQ032, Q10a_SQ022_SQ032, Q10a_SQ023_SQ032, Q10a_SQ024_SQ032, Q10a_SQ025_SQ032, Q10a_SQ026_SQ032, Q10a_SQ027_SQ032)== Q9
Q9 was the matching total. All good!
Cheers,
Kim.
The topic has been locked.