COUNTING CELL

[Rudy]

Hi,

Need help please & it goes like this. I have in column L the words NEW &
EXISTING & in column M the letters Y & N. All I need is to count the number
of NEW & Y as one cell. Same goes with EXISTING & Y. I've tried all sorts of
COUNTIF formula but it always returns zero.

rgds,

rudy

 

[Evi]

I think you may be lost, Rudy, this is the Access newsgroup and you are
talking in Excel.
You could add a third column with the function
=AND(L1="Existing",M1="Y")
and under that have
=CountIf(N1:N6,TRUE)
Hide this column and refer to the answer cell in the place where you want
the data to show
Evi