software

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

Total Y 4 Total N 5

Thanks

Tom
=countif(A:A,quot;nquot;)
=countif(a:a,quot;yquot;)
Tom Grassi wrote:
gt;
gt; I have a spreadsheet that has a column and the contents of the column is
gt; either a quot;Yquot; or quot;Nquot; I would like to know how to count (sum) the number of
gt; quot;Yquot;'s and quot;Nquot;s to give me the total number of quot;Yquot;s and the total number of
gt; quot;Nquot;'s
gt; Column A
gt; Y
gt; Y
gt; Y
gt; Y
gt; N
gt; N
gt; N
gt; N
gt; N
gt;
gt; Total Y 4 Total N 5
gt;
gt; Thanks
gt;
gt; Tom

--

Dave Peterson

Dave

Thanks it works great

Happy Holidays

Tom

quot;Dave Petersonquot; gt; wrote in message
...
gt; =countif(A:A,quot;nquot;)
gt; =countif(a:a,quot;yquot;)
gt;
gt;
gt;
gt; Tom Grassi wrote:
gt;gt;
gt;gt; I have a spreadsheet that has a column and the contents of the column is
gt;gt; either a quot;Yquot; or quot;Nquot; I would like to know how to count (sum) the number of
gt;gt; quot;Yquot;'s and quot;Nquot;s to give me the total number of quot;Yquot;s and the total number
gt;gt; of
gt;gt; quot;Nquot;'s
gt;gt; Column A
gt;gt; Y
gt;gt; Y
gt;gt; Y
gt;gt; Y
gt;gt; N
gt;gt; N
gt;gt; N
gt;gt; N
gt;gt; N
gt;gt;
gt;gt; Total Y 4 Total N 5
gt;gt;
gt;gt; Thanks
gt;gt;
gt;gt; Tom
gt;
gt; --
gt;
gt; Dave Peterson