Problem with foumula

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.
 
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,""),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count entries in columns and rows 3
Countif problem 2
Dynamic sumif function 5
Counting Problem 2
Bug in Excel? 2
COUNTIF with wildcards 3
sum if 1
Over 29 args in a UDF with double parens 1

Top