close

I have a column. The column can have a C or T or U or X. I want to count
the number of each. How can I do this or is there a way?

You could use formulas like:

=countif(a:a,quot;cquot;)
Jim wrote:
gt;
gt; I have a column. The column can have a C or T or U or X. I want to count
gt; the number of each. How can I do this or is there a way?

--

Dave Peterson

=countif(A:A,quot;Cquot;) will count quot;Cquot;s in column A

quot;Jimquot; wrote:

gt; I have a column. The column can have a C or T or U or X. I want to count
gt; the number of each. How can I do this or is there a way?

Thanks. I will give it a try.

quot;Toppersquot; wrote:

gt; =countif(A:A,quot;Cquot;) will count quot;Cquot;s in column A
gt;
gt; quot;Jimquot; wrote:
gt;
gt; gt; I have a column. The column can have a C or T or U or X. I want to count
gt; gt; the number of each. How can I do this or is there a way?

Thanks, I will give it a t ry.

quot;Dave Petersonquot; wrote:

gt; You could use formulas like:
gt;
gt; =countif(a:a,quot;cquot;)
gt;
gt;
gt;
gt; Jim wrote:
gt; gt;
gt; gt; I have a column. The column can have a C or T or U or X. I want to count
gt; gt; the number of each. How can I do this or is there a way?
gt;
gt; --
gt;
gt; Dave Peterson
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()