If Sum Countif Function
 

=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.

If Sum Countif Function
 

=IF(SUM(COUNTIF($A$1:$E$2,1),COUNTIF($A$6:$E$7,1), COUNTIF($A$11:$E$12,1),COU
NTIF($A$16:$E$17,1),COUNTIF($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$41: $E$42,1))=1,1,"")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Cliff" wrote in message
...

=IF(SUM(COUNTIF($A$1:$E$2,1),COUNTIF($A$6:$E$7,1), COUNTIF($A$11:$E$12,1),COU
NTIF($A$16:$E$17,1),COUNTIF($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$41: $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.