+ Reply to Thread
Results 1 to 1 of 1

Summarizing cost data from list by unit #

  1. #1
    Registered User
    Join Date
    12-05-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    6

    Summarizing cost data from list by unit #

    I have a list of data that i need to pull some information from and summarize. The list has many rows of data, i have attached a portion of it (sheet 2). The summary sheet pulls different cost information from the list and sums it. There are 3 different costs i would need to sum, internal labor cost, parts cost, and external labor cost. Each unit has a worksheet that would show each total cost per month (sheet 1 in example). Any help with the formulas for this would be greatly appreciated. I am currently putting the list into a pivot table and manually copying the amounts for each unit into a sheet for each cost type that feeds the summary sheet(example is on sheet 3)

    Thanks!!
    Attached Files Attached Files

+ Reply to Thread

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