COUNTING CELL

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rudy - 05 Apr 2008 07:01 GMT

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

Reply to this Message

Evi - 05 Apr 2008 09:24 GMT

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

> Hi,
>
[quoted text clipped - 6 lines]
>
> rudy

Reply to this Message