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.
Bookmarks