Problem with foumula

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
If Sum Countif Function 1
Countif problem 2
Problem with COUNTIF being off by 1 1
Help with formula 6
Problems with count, counta and countifs 3
Bug in Excel? 2
Dynamic sumif function 5

Back
Top