COUNTIFS - Containing date and blank cell

[SaraStravers]

Hello,

Looking for a solution to this problem:

L2 contains a date
M2 is blank

I need a COUNTIFS statement to count in the range the number of cells where L contains a date but M is blank. Thanks!

[Pete_UK]

Try this:

=COUNTIFS(L:L,">0",M:M,"")

Hope this helps.

Pete