software

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

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


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),COUNTI F(A21:E22,1),COUNTIF(A26:E27,1),COUNTIF(A31:E32,1) ,COUNTIF(A36:E37,1),COUNTIF(A41:E42,1))=1),1,quot;quot;),quot; quot;)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=530301