Hi Fellow Forum Members
I have data organised as follows:

ColB ColD ColG ColK
Yes NA 29/08/14 NA
No 04/04/14 20/01/14 NA
No 04/04/14 03/02/14 03/02/14
No 04/04/14 03/03/14 NA

What I want to do is count the entries where ColK is NA and ColB is No and ColG is less than Col D. Here is the formula I have attempted and failed so far:

=COUNTIFS(B:B,"No",K:K,"NA",G:G,"<D")
Edit: The Green face should refer to the whole of column D.



Any guidance would be appreciated.
Kind regards
Tony