G
Guest
=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),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.
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.