Forum Discussion
Solved
Help needed with putting a value in a specific cell using COUNTIF?
I have the following table: O1 P1 Q1 AA AB AC AD AE I I I 1. How can I make it...
1: =IF(COUNTIF(AA1:AB1,"I")=1,1,"")
this only returns 1 if there is exactly 1 "I" in AA and AB. If you need it to also return 1 if there is an "I" in both AA and AB:
=IF(COUNTIF(AA1:AB1,"I")>1,1,"")
2: =IF(AE1="I",1,"")
3: =IF(COUNTIF(AC1:AD1,"I")=0,1,"")
1: =IF(COUNTIF(AA1:AB1,"I")=1,1,"")
this only returns 1 if there is exactly 1 "I" in AA and AB. If you need it to also return 1 if there is an "I" in both AA and AB:
=IF(COUNTIF(AA1:AB1,"I")>1,1,"")
2: =IF(AE1="I",1,"")
3: =IF(COUNTIF(AC1:AD1,"I")=0,1,"")
- I have another related queston please Jan,
How can I make this formula?
If there is an I or C in cells AB5 to AI5 THEN "" ELSE 1
Many thanks!=IF(COUNTIF(AB5:AI5,"I")+COUNTIF(AB5:AI5,"I")>=1,"",1)
- Thank you so much for helping, Jan!
