+ Reply to Thread
Results 1 to 4 of 4

How to sum List items and separate column values into new worksheets.

  1. #1
    Registered User
    Join Date
    01-12-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    2

    How to sum List items and separate column values into new worksheets.


    Hey guys, thanks for having me.

    Ok heres where I have become stuck:
    I am creating a Spreadsheet for budget managment and also to account for repairs on machinery, what I am looking to do is.

    I have a dropdown bar of machines in column C and Price value for repairs in column H,
    What I want to do is find a way where on a seperate sheet I can just List the machines and get a total cost for that individual item.

    eg:
    Column C Column H
    Mach 1 121
    Mach 2 155
    Mach 3 139
    Mach 2 966
    Mach 1 20,000
    Mach 1 49.25

    Now remember column C is a dropdown bar, how do I total the values on another sheet to read the total per machine?

    Thanks.

    From the most confused person I know

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: How to sum List items and sepeate column values into new worksheets.

    A pivot table perhaps.

  3. #3
    Registered User
    Join Date
    01-12-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: How to sum List items and sepeate column values into new worksheets.

    After a long shift last night I dont think the problem I posted made much sence.
    try this:

    What I want is the Sum of column H, but only from the values (which are in list form so therfor changable) where those values are in that row.

    Also I dont know a great deal about the formula of excel so could you please explain what a pivot table is, Im willing to give anything a go.

    I will link the excel file so you can see what I am trying to do maybe someone could have a look and see how I populate my Overview tab with the correct costs from the months for each individual machine.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,607

    Re: How to sum List items and separate column values into new worksheets.

    If you changed the sheet names or row 2 headings so that they matched, you could try this in C3 and copied down and across:

    =SUMIF(INDIRECT(C$2&"!C:C"),$B3,INDIRECT(C$2&"!H:H"))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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