Adding like items on a column and add qty on a new column

[[email protected]]

From:
5
5
5
7
7
4
4
4

To
Item Qty
5 3
7 2
4 3

Dewey

[[email protected]]

Have I threatened someone here before? Heeeeeeelp!

[Ace_XL]

Good day,

I do not feel threatened

Try using the COUNTIF formula.
=COUNTIF($A$1:$A$8,either of 5,7,or4). Your list of items is in column 'A'.