Help Formula Countif or Countifs

[rentonhighlands]

I want to know how many connections are pending delivery in the state of OR. What function can I use and write a formula for me to see.

sample data

Site State

Carrier Estimated Delivery Date

CA	12/30/2024
CA	12/30/2024
CA	12/30/2024
CA	12/16/2024
CA	12/16/2024
CA	11/27/2024
CA	2/17/2025
CA	1/13/2025
OR	12/30/2024
OR	12/16/2024
OR	12/9/2024
OR	12/12/2024
CA	12/20/2024
OR	1/30/2025
OR	1/30/2025
OR	2/28/2025
OR	2/28/2025
OR	2/28/2025
OR	1/30/2025

 

[Cubist]

What indicates that it's pending?

 

[MARZIOTULLIO]

=COUNTIFS(A1:A19,"OR",B1:B19,">"&TODAY())

 

[rentonhighlands]

What indicates that it's pending?

That there is a date in the cell. Some dates might be in the past.

 

[Cubist]

That there is a date in the cell. Some dates might be in the past.

You need to be clearer. In your sample data, all of your entries have date does that mean they're all pending? If they have date in the past, does it mean it has been delivered?

 

[rentonhighlands]

You need to be clearer. In your sample data, all of your entries have date does that mean they're all pending? If they have date in the past, does it mean it has been delivered?

In your sample data, all of your entries have date does that mean they're all pending? Yes
If they have date in the past, does it mean it has been delivered? Yes and no, see the issue is sometimes the PM has not updated the date.

 

[Cubist]

Yes and no, see the issue is sometimes the PM has not updated the date.

Then how would you like the formula to handle this scenario?