Problem with foumula

C

Cliff

=IF(A1=1,IF(OR(COUNTIF(A1:AS2,1)=2,SUM(COUNTIF(A6:E7,1),COUNTIF(A11:E12,1),COUNTIF(A16:E:17,1),COUNTIF(A21:E22,1),COUNTIF(A26:E27,1)COUNTIF(A31:E32,1),COUNTIF(A36:E37,1),COUNTIF(A41:E42,1)=1),1,""),""))

I am having a problem with the above formula. When I enter it in cell A4,
the cell returns False and when I put a number 1 in A1, the cell returns #
Value.

Any help would be appreciated.
 
D

daddylonglegs

Perhaps it should be...

=IF(A1=1,IF(OR(COUNTIF(A1:AS2,1)=2,SUM(COUNTIF(A6:E7,1),COUNTIF(A11:E12,1),COUNTIF(A16:E17,1),COUNTIF(A21:E22,1),COUNTIF(A26:E27,1),COUNTIF(A31:E32,1),COUNTIF(A36:E37,1),COUNTIF(A41:E42,1))=1),1,""),"")
 
Top