One way would be to create a Pivottable:
Row Items: ID and Amount
Data Item: ID (count)

Ola Sandstrom


Example:
ID...Amount.... Count of ID
xx...500..........3
.......250..........1
yy...400..........4
.......130..........1