I have a range of cells with various values (dates, letter N, letter P). I
want to count the number of cells within the range that don't have the letter
N. I don't want to add contents, just get the number of cells that contain a
value. Can someone tell me how this is done?
--
-----------
Thanks,
Steve

SteveT, here is one way,
=COUNTA(A1:A20)-COUNTIF(A1:A20,"n")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"SteveT" <(E-Mail Removed)> wrote in message
news:5D869053-0935-49F7-8FCA-(E-Mail Removed)...
> I have a range of cells with various values (dates, letter N, letter P).
I
> want to count the number of cells within the range that don't have the
letter
> N. I don't want to add contents, just get the number of cells that
contain a
> value. Can someone tell me how this is done?
> --
> -----------
> Thanks,
> Steve

How does this question relate to your topic.

i = Application.Countif(Range("A1:Z26"),"<>N")

j = Application.CountBlank(Range("A1:Z26"))



--
Regards,
Tom Ogilvy


"SteveT" <(E-Mail Removed)> wrote in message
news:5D869053-0935-49F7-8FCA-(E-Mail Removed)...
>I have a range of cells with various values (dates, letter N, letter P). I
> want to count the number of cells within the range that don't have the
> letter
> N. I don't want to add contents, just get the number of cells that
> contain a
> value. Can someone tell me how this is done?
> --
> -----------
> Thanks,
> Steve