Counting blank cells

Sean Maney

I need to use COOUNTIFS to count cells that are blank when TODAY is greater than the Bid Due Date. Here is what I have so far:

=COUNTIFS(isblank[R2 Submitted Date]@row), TODAY (0) >[Bid Due Date]@row)

Eric Law

Hello @Sean Maney

This is similar to your other problem where you are combining the range with the criteria.

Try =COUNTIFS([R2 Submitted Date]:[R2 Submitted Date], "", [Bid Due Date]:[Bid Due Date], < Today() )