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 Grassi wrote:

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

--

Dave Peterson

Dave

Thanks it works great

Happy Holidays

Tom

"Dave Peterson" wrote in message
...
=countif(A:A,"n")
=countif(a:a,"y")



Tom Grassi wrote:

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

--

Dave Peterson