M
Michael J. Malinsky
Assuming the range you are trying to count is from A1 to A25 use:
=COUNTA(A1:A25)
HTH
=COUNTA(A1:A25)
HTH
D
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.
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.
D
Dave R.
=COUNTIF(A:A,"y")
will count the whole column for Y.
if you want just a range, try
=COUNTIF(A1:A10,"y")
will count the whole column for Y.
if you want just a range, try
=COUNTIF(A1:A10,"y")
D
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.
empty cell, where Dave B. only wants to count "y"s.
B
Bob Umlas
No, that'd count any character, not just "Y".
Use =COUNTIF(A1:A25,"Y")
Use =COUNTIF(A1:A25,"Y")
M
Michael J. Malinsky
Whoops...sorry...had a headache at the time. 