Summarise a spreadsheet

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

Hi and welcome to the board
There are various ways to solve this, one of them being a Pivot Table.
Select a cell in your list Click data - Pivot Tables and follow the wizard

HTH

thanks arthur, i'll give it a bash