View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve[_15_] Steve[_15_] is offline
external usenet poster
 
Posts: 3
Default Formula to total labor charges

I have a workbook, containing multiple sheets, and each sheet is named
according to an employee's name. Each employee's sheet contains a Customer
name in column C, preceded by the total labor charge that the mechanic
billed to that customer for each invoice generated in column A.

Column B contains the total parts the mechanic billed to that customer, with
each invoice on a separate row, just like the labor column. Column D
contains the date of each invoice.



I am trying to build a sheet which will give me the breakdown of each
employee's total labor charged per customer, per day.



Ex:



Column A (Labor) Column B (Parts) Column C (Company)
Column D (Date)

$50.00 $25.00 Acme
11/1/2008

$75.00 $50.00 Pathmark
11/1/2008

$50.00 $25.00 Superfresh
11/1/2008

$75.00 $50.00 Acme
11/1/2008

$50.00 $25.00 Acme
11/2/2008

$75.00 $50.00 Pathmark
11/1/2008

$50.00 $25.00 Superfresh
11/1/2008

$75.00 $50.00 Pathmark
11/2/2008



Would return:



Column A (Company) Column B (Date) Column C (Labor)

Acme 11/1/2008 $125

Acme 11/2/2008 $50

Pathmark 11/1/2008 $150

Pathmark 11/2/2008 $75

Superfresh 11/1/2008 $100





Thanks in advance for any assistance...



---

Steve