How to count letters

[zkiraly]

Hi,

If I have letters written in some of the cells of a column (instead of numbers), what formula can I use to tell excel to count up the number cells that have letters in the column?

Thank You

 

[Scott Huish]

If I'm understanding your question correctly, you have a column with numbers in some cells and letters in others and you want to know how many have numbers in them. Is this correct?

If so, perhaps:

Formula in F1:
=COUNT(D1:D6)

Book4.xls
	D	E	F	G
1	1		3
2	A
3	2
4	B
5	B
6	3
Sheet1

 

[Aladin Akyurek]

Provide a tiny sample along with the desired result.

 

[zkiraly]

Ok,

let's say the following information is in column G:

"DW" is in cell G10
"D" is in cell G14
"DW" is in cell G20

So 3 cells in column G have writing in them. How can I get excel to return the number 3 in cell H1, for example. No cells in column G will contain numbers, I am only talking about counting up the cells in column G that contain writing.

 

[Scott Huish]

OK,

It sounds like it's either text or nothing, so how about something like this:
=COUNTA(G1:G100)