Count Items Passed Due Date if Status is Open

[Zu0001]

Need a formula to count how many items with a Status of "Open" in column E have surpassed the Due Date in Column G.

 

[etaf]

=countifs($E$2:$E$100,"Open",$G$2:$G$100,"<"&today())

Book1
	E	F	G	H	I
1
2	closed		2/1/24		1
3	open		6/1/24
4	closed		2/1/24
5	open		1/1/24
Sheet1

Cell Formulas
Range	Formula
I2	I2	=COUNTIFS($E$2:$E$101,"Open",$G$2:$G$101,"<"&TODAY())

 

[bobsan42]

this should be the easiest to comprehend:

=COUNTIFS(E:E,"Open",G:G,"<"& TODAY())

with the added benefit of case-insensitive text comparison.

 

[Zu0001]

Thank you so much. This is excellent. Problem solved.

 

[etaf]

you are welcome