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

Please post a sample sheet ( no pics please) - Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Quick and dirty, make another column that calculates if G<D then use that result in your equation. The text "NA" in the first row of D might throw a wrench in the calculation that you may have to consider.