IF/AND statement with a Countif included
Hi,
Am Tue, 6 Aug 2019 10:44:11 -0700 (PDT) schrieb Sabosis:
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.
then try:
=IF(AND(A2="TT",COUNTBLANK(A5:A8)0),"Yes","")
or
=IF(AND(A2="TT",COUNTIF(A5:A8,"")),"Yes","")
Regards
Claus B.
--
Windows10
Office 2016
|