Excel Formula Needed

[JDayco]

Good day,

I am wondering if it would be possible to use an excel formula (IF or something) to count entries with 'awaiting' statuses that are due to be completed today. Sort of a two criteria - count?

See the

screenshot below.

Thanks in advance!

 

[Fluff]

How about

=COUNTIFS(F:F,"awaiting",A:A,B1)

 

[JDayco]

Thank you so much! That worked well!

 

[Fluff]

You're welcome & thanks for the feedback.