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