Check if cell is blank with additional criteria

[mart_mrexcel]

I was trying to put an indicator message as "Product Expired with No Date▼" in the above heading of date with 2 criteria, that is Expired as "Yes" and Date is blank, using the below formula and it does not work. In below, the message indicator should appear since Prd-001 is Yes and the date if blank.

	A	B	C	D	E
1			=IF(AND(COUNTIF(B3:B5,"="&"Yes"),isblank(C3:C5)),"Product Expired with No Date▼","")
2	Product Code	Expired?	Date
3	Prd-001	Yes
4	Prd-002
5	Prd-003	Yes	January 30, 2024

 

[Cubist]

Try:

=IF(COUNTIFS(B3:B5,"Yes",C3:C5,"<>")>0,"Product Expired with No Date▼","")

 

[Alex Blakenburg]

I would have thought the other way around.

Book2
	A	B	C	D	E
1				Product Expired with No Date▼	<---- Formula
2	Product	Expired	Date
3	Prd-001	Yes
4	Prd-002
5	Prd-003	Yes	28/04/2024
Sheet1

Cell Formulas
Range	Formula
D1	D1	=IF(COUNTIFS(B3:B5,"Yes",C3:C5,"")>0,"Product Expired with No Date▼","")

 

[Cubist]

Thought I removed the <>. Whoops.