View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Sabosis Sabosis is offline
external usenet poster
 
Posts: 47
Default 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.