HELP!!!! sumif or sumproduct ??? :(

[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

 

[Ron H]

What error are you getting with Pivot Tables?
Make sure there are no blank cells in your "dates" columns, then you
should be able to group dates by weeks, months, or years.
Is your "date" recognized as a date or is it "text"?

 

[Wally]

Pivot table just gives me a total of the tickets, not a total of the
net weights.

it tells me hl3n31 31 tickets, but not the total of 34,567 kgs.

 

[Roger Govier]

If you drag Net to the data area as well, double click on the filed name and
choose Sum, then you will have weight as well as count of tickets.

 

[WTG]

sorry, I must be doing something wrong.

I get plant id, then product...but for net I get every weight for
every product... I just need the total for each product.

I double clicked on both product and net to pick SUM, by it didn't
change it.

Also once I have the year to date total I still need to pull up
monthly totals, can i do that with a pivot table?

Thanks

Wally

 

[Roger Govier]

Hi Wally
If you want to eamil a copy of the file direct to me I will take a look at
it for you.
Remove NOSPAM from my address to send