Hi guys,

Hopefully someone can help me.

I've got a input spreadsheet with various clients and what they are been billed. The clients are often repeated in this spreadsheet and i want to create a summarised sheet that does adds all the clients billings together and shows it in one row.

i.e.
INPUT

Bread 5$
Milk 1$
Coke 1$
Bread 5$
Milk 1$

RESULT

Bread 10$
Milk 2$
Coke 1$


Thanks