Results 1 to 3 of 3

Eliminating common names while creating one name with summed values

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2010
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Eliminating common names while creating one name with summed values

    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.
    Last edited by nocty; 02-24-2010 at 03:50 PM. Reason: Forum Rules

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1