Hi,

Am Tue, 6 Aug 2019 09:16:41 -0700 (PDT) schrieb Sabosis:

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.

you put the brackets wrong.
Try:
=IF(AND(A2="TT",COUNTIF(A5:A8,0)),"Yes","")


Regards
Claus B.
--
Windows10
Office 2016