Hi,

Guess I went to the wrong office discussion group (Access). Anyway, can
someone assist please. I have in column L the words NEW & EXISTING & in
column M the letters Y & N. What I need is to count how many cell that has
NEW & Y (to be counted as one) & likewise same with EXISTING & Y. I've tried
all sort of COUNTIF functions but it always return zero. Thanks.

rgds,

rudy