Eliminating common names while creating one name with summed values

[nocty]

Hello, I am building an excel spreadsheet that basically has the same problem name with different values through out the month. For example

Hotdogs - 25
Hotdogs - 30
Hotdogs - 20
Hotdogs - 15
Pizza - 10
Pizza - 15
Pizza - 20
Pizza - 5
Soda - 10
Soda - 15
Soda - 20
Soda - 15

I would like to Sum the values and create one unique record for my reports such as
Hotdogs - 90
Pizza - 50
Soda - 60

I have figured out how to use the Sumif function but I do not know how to create one record with the sum totals. Any help would be much appreciated.

Thank you for your help.

[Leith Ross]

Hello nocty,

The attached workbook has 2 sheets: List and Report. The List contains the example data you posted. The Report sheet contains the names and the counts. This macro could be adapted to your workbook. However, without seeing your workbook I can't make any needed adjustments. The macro below has been added to a button on the List sheet.

Please Login or Register  to view this content.

[DonkeyOte]

Or alternatively use a Pivot Table - for general intro see link in sig.

Pivots are purpose built for this type of aggregation work.

IMO - Pivots should be the first thing any XL user gets to grip with as they can literally hours of work - they require no formula knowledge per se and offer immense reporting power & flexibility for no effort.
(they also illustrate why it's a good idea to store "transactional" data in a tabular manner as you have done)