Error checking

Hi,
I am making up an inputs spread sheet and trying to include some formulas which will check to see if there has been some errors. I have attached an example sheet so you will hopefully understand my problem
I am currently using "if" and "Count" but there not good enough as you will see in the example.
Each section should only have one tick (i'm using 1 as a tick as i need the numbers further in the sheet) which means test 1 is right, test 2 the check works but for test 3 as there is two mistakes they cancel each other out.
Is there a better way which will prevent this?

Thanks in advance for your help
Kello

not sure if i understand you, but try this in F4, copied down?

=IF(COUNT(C4:E4)>1,"Error","")

ok try this, it is not very pretty, but gives you what you want...
=IF(OR(COUNTIFS(C4:C23,">"&0,$F$4:$F$23,"Section 1")>1,COUNTIFS(C4:C23,">"&0,$F$4:$F$23,"Section 2")>1,COUNTIFS(C4:C23,">"&0,$F$4:$F$23,"Section 3")>1,COUNTIFS(C4:C23,">"&0,$F$4:$F$23,"Section 4")>1,COUNTIFS(C4:C23,">"&0,$F$4:$F$23,"Section 5")>1),"too many inputs","No Error")