IF/AND statement with a Countif included
On Tuesday, August 6, 2019 at 9:16:45 AM UTC-7, Sabosis wrote:
Hello
I need a formula that can validate a cells contents and also do a count in a range to show me if that range is empty. What is the easiest way?
=if(and((A2="TT",Countif(a5:A8,0),"YES,""))) ....this obviously doesn't work but it is what I am trying to accomplish.
Thanks in advance for any help on how to achieve this
Thanks. I am not getting an error, but I am not seeing a YES for when both conditions match either. I have TT in A2 and blanks in A5:A8. I would want to see YES for these conditions.
|