=IF(SUM(COUNTIF($A$1:$E$2,1),COUNTIF($A$6:$E$7,1), COUNTIF($A$11:$E$12,1),COUNTIF($A$16:$E$17,1),COUN TIF($A$21:$E$22,1),COUNTIF($A$26:$E$27,1),COUNTIF( $A$31:$E$32,1),COUNTIF($A$36:$E$37,1),COUNTIF($A$4 1:$E$42,1)=1),1,"")

I am having trouble with the above formula. It appears to be only looking
at the first group of cells (A1:E2) when I am trying to get it to look at all
of the listed non adjacent groups of cells and return a 1 if only one number
1 is located.

Any help would be appreciated.