Re: COUNTIF

Maybe you have calculation set to manual???

You sure your data is in L1:M100?

I'm pretty much out of ideas.

Rudy wrote:

Hi,

Confirm there's no extra spaces in both coulums.

rgds,

rudy

"Dave Peterson" wrote:

Check your cells with the data.

Make sure you don't have any extra spaces (leading or trailing) in cells in both
ranges.



Rudy wrote:

Hi,

I've just copy & paste Biff's formula below on my spread***, however,
result still returns "0".

rgds,

rudy

"Fred Smith" wrote:

What is "it" that's returning zero? Show us the formula you are using so we
can help you. Biff's formula will work when used properly.

Regards,
Fred.

"Rudy" <Rudy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A036FBE9-7EDB-4FC0-A30F-799BF2531153@xxxxxxxxxxxxxxxx
Hi,

It still returns zero. Don't know why. Below is the format. Just want to
count how many has NEW & Y, EXISTING & Y. Thanks.

L M

NEW Y
EXISTING N
NEW N
NEW Y
NEW Y
NEW N
EXISTING Y
EXISTING Y
NEW N
NEW Y




"T. Valko" wrote:

Try these:

=SUMPRODUCT(--(L1:L100="new"),--(M1:M100="y"))

=SUMPRODUCT(--(L1:L100="existing"),--(M1:M100="y"))

Note that you can't use entire columns as range references with
SUMPRODUCT
(unless you're using Excel 2007).


--
Biff
Microsoft Excel MVP


"Rudy" <Rudy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A57D6DC6-E93F-450F-B011-AD6DBAB5D045@xxxxxxxxxxxxxxxx
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






--

Dave Peterson


--

Dave Peterson
.