A pivot table would let you this quickly and without formulas.
- Select your table (in your example, just this one column), including the header name
- Click "Insert PivotTable"
- Click OK.
An empty PivotTable is created. On the field list on the right, you see one field which has your column's name.
- Drag and drop the field to the Row Labels section below.
- Drag it once more to the Values section below. It should show "Count of column name". (If not, you must set it to count).
You should now have a table with the number of occurences for each item.