View Single Post
  #1   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

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