Newbie Question Column Adding Please Help

  • Thread starter Thread starter Tom Grassi
  • Start date Start date
T

Tom Grassi

I have a spreadsheet that has a column and the contents of the column is
either a "Y" or "N" I would like to know how to count (sum) the number of
"Y"'s and "N"s to give me the total number of "Y"s and the total number of
"N"'s
Column A
Y
Y
Y
Y
N
N
N
N
N

Total Y 4 Total N 5




Thanks

Tom
 
=countif(A:A,"n")
=countif(a:a,"y")



Tom said:
I have a spreadsheet that has a column and the contents of the column is
either a "Y" or "N" I would like to know how to count (sum) the number of
"Y"'s and "N"s to give me the total number of "Y"s and the total number of
"N"'s
Column A
Y
Y
Y
Y
N
N
N
N
N

Total Y 4 Total N 5

Thanks

Tom
Click to expand...
 
Back
Top