S
Steve
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...
"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...