Yes / No Formula for Open items only

[JasAujla]

Hi,

I have a RAID log and need a formula to check if the risks were updated on a specific date. Please see image attached.

Logic: Formula to check date in A2 and see if all OPEN items have the same date if criteria met YES if not NO (All Open items must have the date in cell A2 for a YES)

I need the formula to disregard CLOSED items as well please. Two criteria searches one for date in A2 in column F and only look for that date for OPEN items and ignore CLOSED.

 

[Fluff]

Hi & welcome to MrExcel.
Maybe

=IF(COUNTIFS(G:G,"Open")=COUNTIFS(F:F,A2,G:G,"Open"),"Yes","No")

 

[JasAujla]

Perfect exactly what I needed logic seems so simple

 

[Fluff]

You're welcome & thanks for the feedback.

 

[JasAujla]

One more thing please if you could assist.

If I wanted to add more criteria where would I add this within the formula that you have provided?

Example: OPEN, DATE and RAG STATUS = H

 

[Fluff]

Maybe

=IF(COUNTIFS(G:G,"Open")=COUNTIFS(F:F,A2,G:G,"Open",H:H,"Rag status"),"Yes","No")

 

[JasAujla]

Brilliant works a treat

 

[Fluff]

My pleasure.