USE OF COUNT OR COUNTIF FUNCTION

[Guest]

WHAT IF I WANT TO COUNT IN A COLUMNT ONLY THE CELLS WHICH 'VE CHARACTER

AND WHAT IF I WANT TO COUNT IN A COLUMNT ONLY THE CELLS WHICH 'VE ONLY NUMERIC FIELD

 

[Frank Kabel]

Hi
first please turn off your CAPS-LOCK: makes it difficult to read and is
considered as shouting in a NG

1. count cells with characters
=SUMPRODUCT(--(NOT(ISNUMBER(A1:A1000))),--(A1:A1000<>""))

2. Count cells with numeric entries
=SUMPRODUCT(--(ISNUMBER(A1:A1000)))

 

[Guest]

sorry for the caps loc
my friend can u tell me how i can use it with count and countif function?

thanks for u r reply ne ways i want to make it simple actualy
----- Frank Kabel wrote: ----

H
first please turn off your CAPS-LOCK: makes it difficult to read and i
considered as shouting in a N

1. count cells with character
=SUMPRODUCT(--(NOT(ISNUMBER(A1:A1000))),--(A1:A1000<>"")

2. Count cells with numeric entrie
=SUMPRODUCT(--(ISNUMBER(A1:A1000))


-
Regard
Frank Kabe
Frankfurt, German


MURTAA wrote

 

[Frank Kabel]

Hi
not really possible with COUNTIF. Therefore I gave you the workaround
with SUMPRODUCT.

 

[David McRitchie]

Hi murtaza,
You can take a look at John Walkenbach's page and see if you
find something there more to your liking. But the refusal of an answer
sounds a lot like homework as opposed to getting results.
Excel Developer Tip: Cell Counting Techniques
http://www.j-walk.com/ss/excel/tips/tip52.htm

COUNT and COUNTA - COUNT
might be what you are looking for.

I would also suggest downloading Peter Noneley's workbook (276KB)
Excel Function Dictionary
http://homepage.ntlworld.com/noneley/

The change from all uppercase to all lowercase is also
not appropriate but at least is a bit more readable. I would think that
in asking a question you would want to make it as easy as possible
for someone to read and understand your question and use of the
spelling checker would also help.

Most people in these groups are professionals.