<div>
=countif(A:A,&quot;apple&quot;)
</div>


<div>
Or if B1 contains apple then you can use<br />
<br />
=countif(A:A,B1)
</div>


Or if B1 contains apple then you can use

=countif(A:A,B1)

EE-Pivot-Example.xls

<div>
Thank you for providing an example of a pivot table. &nbsp;I have never used pivot tables.
</div>


Thank you for providing an example of a pivot table.  I have never used pivot tables.

<div>
Glad to help. &nbsp;PivotTables are amazingly powerful and are especially good at *ad hoc* analysis of your data.<br />
-Glenn
</div>


Glad to help.  PivotTables are amazingly powerful and are especially good at *ad hoc* analysis of your data.
-Glenn

<div>
<div class="content wysiwyg-content">
Running Excel 2000 on Windows XP Pro. &nbsp;<br />
<br />
I have a column containing repeating values. &nbsp;I want to get a count of each repeating value.<br />
For example, column F has the word &quot;apple&quot; in several cells. &nbsp;in the same column there are many cells containing &nbsp;the word &quot;bake&quot;. &nbsp;<br />
<br />
What function would count the cells in the row and tell me how many contain &quot;bake&quot; and how many contain &quot;apple&quot; ?
</div>
</div>


Running Excel 2000 on Windows XP Pro.  

I have a column containing repeating values.  I want to get a count of each repeating value.
For example, column F has the word "apple" in several cells.  in the same column there are many cells containing  the word "bake".  

What function would count the cells in the row and tell me how many contain "bake" and how many contain "apple" ?

How to count repeating values

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.