W
Wally
I'm sorry, I'm very greatful for all the help you've been giving me...
But no matter what I try I just can't get this to work..
below is a sample of my data worksheet "TICKETS", and below that is a
sample of my worksheet "sum".
I can get the Y-T-D totals by using
(=SUMIF(TICKETS!$G$2:$L$10000,'Productsummary'!$A9,TICKETS!$K$2:$K$10000)
But now I need to total buy months, I've tried different sumif's, sum
product's and even pivot tables.............
I ethier get errors or 0,
Any ideas would be greatly appreciated.
Thanks
Wally
SHEET " TICKETS"
PLANT TICKET # DATE CUST PRODUCT TRUCK
NET
I404 1297762 01/04/05 HOLL06 PITRUN HOLLANDIA
10.85
I404 1297763 01/04/05 HOLL06 PITRUN HOLLANDIA
13.56
I404 1297764 01/04/05 HOLL06 PITRUN HOLLANDIA
13.45
I31-04 1297812 05/03/05 TERA01 COLD MIX TERANOR811
19.66
I404 1297813 05/04/05 PATT02 PITRUN LAFRENIERE
16.83
I404 1297814 05/04/05 PATT02 PITRUN PAT_TAYLOR
22.27
I404 1297815 05/04/05 PINE02 1-1/4" ST PINE_RIDGE
8.61
I404 1297816 05/04/05 RMT01 GRAN A RMT-537 16.23
I404 1297824 05/06/05 PINE02 1-1/4" ST PINE_RIDGE
9.27
I404 1297825 05/06/05 PINE02 1-1/4" ST PINE_RIDGE
9.30
SHEET " SUM"
Y-T-D JAN FEB MAR
APR MAY
COLD MIX COLD MIX 785.74
HL2N21 HL2 100.26
HL3N31 HL3 1119.49
HL3N32 HL3 0
HL3N39 HL3 2479.8
But no matter what I try I just can't get this to work..
below is a sample of my data worksheet "TICKETS", and below that is a
sample of my worksheet "sum".
I can get the Y-T-D totals by using
(=SUMIF(TICKETS!$G$2:$L$10000,'Productsummary'!$A9,TICKETS!$K$2:$K$10000)
But now I need to total buy months, I've tried different sumif's, sum
product's and even pivot tables.............
I ethier get errors or 0,
Any ideas would be greatly appreciated.
Thanks
Wally
SHEET " TICKETS"
PLANT TICKET # DATE CUST PRODUCT TRUCK
NET
I404 1297762 01/04/05 HOLL06 PITRUN HOLLANDIA
10.85
I404 1297763 01/04/05 HOLL06 PITRUN HOLLANDIA
13.56
I404 1297764 01/04/05 HOLL06 PITRUN HOLLANDIA
13.45
I31-04 1297812 05/03/05 TERA01 COLD MIX TERANOR811
19.66
I404 1297813 05/04/05 PATT02 PITRUN LAFRENIERE
16.83
I404 1297814 05/04/05 PATT02 PITRUN PAT_TAYLOR
22.27
I404 1297815 05/04/05 PINE02 1-1/4" ST PINE_RIDGE
8.61
I404 1297816 05/04/05 RMT01 GRAN A RMT-537 16.23
I404 1297824 05/06/05 PINE02 1-1/4" ST PINE_RIDGE
9.27
I404 1297825 05/06/05 PINE02 1-1/4" ST PINE_RIDGE
9.30
SHEET " SUM"
Y-T-D JAN FEB MAR
APR MAY
COLD MIX COLD MIX 785.74
HL2N21 HL2 100.26
HL3N31 HL3 1119.49
HL3N32 HL3 0
HL3N39 HL3 2479.8