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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top