Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to sum up customers totals from other sheets
I am trying to construct a formula which will add to a sheet called
"Totals" the amount of parts and labor a person billed to each customer. The customer name is listed in column "A". The total labor for that customer is listed in column "B". The total parts for that customer is listed in column "C".There are 10 different customer names, each placed consecutively in cells "A3" to "A12". I have several different sheets, each titled with the mechanics name. Each sheet belonging to a particular mechanic is identical to the other. In column "A" there is the total amount of labor he invoiced, per single bill. In column "B" there is the total amount of parts he invoiced for that same bill. In column "C" there is the customer name. Sheet "Bob" A2(Labor) B2(Parts) C2(Cust. name) $100 $50 Alpha $125 $75 Bravo $150 $100 Alpha $50 $50 Charlie Sheet "Tom" A2(Labor) B2(Parts) C2(Cust. name) $100 $50 Alpha $125 $75 Bravo $150 $100 Alpha Sheet "Totals" Desired A3(Cust. name) B3(Labor) C3(Parts) Alpha $500 $300 Bravo $250 $150 Charlie $50 $50 So basically, Sheet "Totals" places the labor totals & parts totals from the mechanics sheets according to each customer's name. Thanks in advance for any assistance... --- Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to sum up customers totals from other sheets
My apologies. I posted this in the wrong group.
Sending to: microsoft.public.excel.worksheet.functions --- Steve On Sep 15, 8:18*pm, " wrote: I am trying to construct a formula which will add to a sheet called "Totals" the amount of parts and labor a person billed to each customer. The customer name is listed in column "A". The total labor for that customer is listed in column "B". The total parts for that customer is listed in column "C".There are 10 different customer names, each placed consecutively in cells "A3" to "A12". I have several different sheets, each titled with the mechanics name. Each sheet belonging to a particular mechanic is identical to the other. In column "A" there is the total amount of labor he invoiced, per single bill. In column "B" there is the total amount of parts he invoiced for that same bill. In column "C" there is the customer name. Sheet "Bob" A2(Labor) * * * B2(Parts) * * * C2(Cust. name) $100 * * * * * *$50 * * * * * * Alpha $125 * * * * * *$75 * * * * * * Bravo $150 * * * * * *$100 * * * * * *Alpha $50 * * * * * * $50 * * * * * * Charlie Sheet "Tom" A2(Labor) * * * B2(Parts) * * * C2(Cust. name) $100 * * * * * *$50 * * * * * * Alpha $125 * * * * * *$75 * * * * * * Bravo $150 * * * * * *$100 * * * * * *Alpha Sheet "Totals" Desired A3(Cust. name) *B3(Labor) * * * C3(Parts) Alpha * * * * * $500 * * * * * *$300 Bravo * * * * * $250 * * * * * *$150 Charlie * * * * $50 * * * * * * $50 So basically, Sheet "Totals" places the labor totals & parts totals from the mechanics sheets according to each customer's name. Thanks in advance for any assistance... --- Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to reach goal percentage of migrating customers | Excel Discussion (Misc queries) | |||
Totals linked from other sheets | Excel Worksheet Functions | |||
specific totals from sheets represented on other sheets | Excel Discussion (Misc queries) | |||
Formula to sum up customers totals from other sheets | Excel Worksheet Functions | |||
Formula for counting customers waiting to be served | Excel Programming |