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

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