Count alpha value in a column.

[Michael J. Malinsky]

Assuming the range you are trying to count is from A1 to A25 use:

=COUNTA(A1:A25)

HTH

 

[dave b.]

Office CP PROF - EXCEL
Have a spreadsheet with columns where "Y" is entered if
desired.
I need to count the number of "y" instances in a column.
Have worked the excel help but can't get it to work.

 

[Dave R.]

=COUNTIF(A:A,"y")

will count the whole column for Y.
if you want just a range, try

=COUNTIF(A1:A10,"y")

 

[Dave R.]

Michael I must point out that your count will count any instance of a non
empty cell, where Dave B. only wants to count "y"s.

 

[Bob Umlas]

No, that'd count any character, not just "Y".
Use =COUNTIF(A1:A25,"Y")

 

[Michael J. Malinsky]

Whoops...sorry...had a headache at the time.