How would I count the quantities in this table.

[tails1]

Hi guys,

In the attached table I'd like to count how many of each type of drink there are, what's the best way to do this? Some kind of pivot table or IF?

Thanks very much.