=SUMPRODUCT(--('Query Info'!$D$1:$D$65000=Code!$L32),--('Query Info'!$F$1:$F$65000=Code!N$2,'Query Info'!$I$1:$I$65000)
Column D is a zone number, F is a door number, and I is ticket numbers. It currently takes each zone, breaks it down by door, and lists the total number of tickets. I need to add a feature so that an additional column (BATCH NUMBER), will be looked into as well. By this, I mean that it will not sum the tickets unless the batch number is = to a certain value.
Thanks!
Excel 2002
this is a little view of the data i'm dealing with.
Column D is a zone number, F is a door number, and I is ticket numbers. It currently takes each zone, breaks it down by door, and lists the total number of tickets. I need to add a feature so that an additional column (BATCH NUMBER), will be looked into as well. By this, I mean that it will not sum the tickets unless the batch number is = to a certain value.
Thanks!
Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | 1 | ||||||||||
2 | |||||||||||
3 | LOAD | ||||||||||
4 | LOAD | TRIP | ZN | BIN | DOOR | DIV | ITM | ||||
5 | DT | NO | NO | NO | NO | NO | NO | TICKETS | |||
6 | ---------- | ---- | --- | ------------ | ---- | ---- | ------- | ----------- | |||
7 | 8/5/2010 | 10 | B71 | 7.94E+08 | 65 | 671 | 16431 | 1 | |||
8 | 8/5/2010 | 10 | A09 | 7.81E+08 | 66 | 642 | 70121 | 1 | |||
9 | 8/5/2010 | 10 | B71 | 7.91E+08 | 72 | 609 | 21805 | 45 | |||
10 | 8/5/2010 | 10 | AJP | 7.91E+08 | 74 | 606 | 21874 | 1 | |||
11 | 8/5/2010 | 10 | A09 | 7.65E+08 | 74 | 642 | 70151 | 2 | |||
12 | 8/5/2010 | 10 | A09 | 7.65E+08 | 74 | 646 | 94683 | 1 | |||
13 | 8/5/2010 | 6 | A09 | 7.65E+08 | 74 | 642 | 70181 | 2 | |||
14 | 8/5/2010 | 6 | A09 | 7.65E+08 | 74 | 609 | 59355 | 1 | |||
15 | 8/5/2010 | 6 | A09 | 7.65E+08 | 74 | 642 | 71123 | 1 | |||
16 | 8/5/2010 | 6 | A09 | 7.65E+08 | 74 | 609 | 1255 | 2 | |||
17 | 8/5/2010 | 6 | A09 | 7.65E+08 | 74 | 642 | 70101 | 1 | |||
18 | 8/5/2010 | 6 | A09 | 7.81E+08 | 74 | 609 | 13990 | 1 | |||
Query Info |
this is a little view of the data i'm dealing with.