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