If Sum Countif Function

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
=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)
 
Back
Top