texasalynn
Well-known Member
- Joined
- May 19, 2002
- Messages
- 8,458
Ok I know I've done these before, but I must be off in Neverland.
=SUMPRODUCT((MONTH(Sheet1!$A$3:$A$54)=6)*(Sheet1!$F$3:$F$54=Tonnage!D30*1)*(Sheet1!$H$3:$H$54=RIGHT(Tonnage!E30,1)))
Need all the months = 6
account to be a number so *1
look at the group, mine has combined info so take the right 1 character
What am I missing?
US Foodservice SR Final 12-14-05.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Acct Site | Weight or | ||||||||
2 | Date | Seq Truck | Cpty Ld% | Quantity | Uom | Account | Location | Group | ||
3 | 06/03 | 2 1 600017 | 7.75 | TN | 22350 | 00004 | 3 | |||
4 | 06/03 | 3 1 600017 | 3.43 | TN | 22350 | 00004 | 1 | |||
5 | 06/10 | 6 1 600021 | 9.07 | TN | 22350 | 00004 | 3 | |||
6 | 06/11 | 1 1 690026 | 2.31 | TN | 22350 | 00004 | 1 | |||
7 | 06/17 | 1 1 667058 | 5.49 | TN | 22350 | 00004 | 3 | |||
8 | 06/17 | 2 1 667058 | 8.41 | TN | 22350 | 00004 | 1 | |||
9 | 06/24 | 2 1 600021 | 7.26 | TN | 22350 | 00004 | 3 | |||
10 | 06/24 | 7 1 600021 | 4.21 | TN | 22350 | 00004 | 1 | |||
11 | 07/01 | 2 1 600021 | 6.46 | TN | 22350 | 00004 | 3 | |||
12 | 07/01 | 3 1 600021 | 2.6 | TN | 22350 | 00004 | 1 | |||
13 | 07/08 | 2 1 600021 | 5.81 | TN | 22350 | 00004 | 3 | |||
14 | 07/08 | 3 1 600021 | 2.93 | TN | 22350 | 00004 | 1 | |||
15 | 07/15 | 1 1 600017 | 7.57 | TN | 22350 | 00004 | 3 | |||
16 | 07/15 | 2 1 600017 | 5.18 | TN | 22350 | 00004 | 1 | |||
17 | 07/22 | 3 1 600019 | 3.04 | TN | 22350 | 00004 | 1 | |||
18 | 07/22 | 4 1 600019 | 7.32 | TN | 22350 | 00004 | 3 | |||
19 | 07/29 | 6 1 600019 | 3.08 | TN | 22350 | 00004 | 1 | |||
20 | 07/29 | 7 1 600019 | 8.76 | TN | 22350 | 00004 | 3 | |||
21 | 08/05 | 4 1 689239 | 2.43 | TN | 22350 | 00004 | 1 | |||
22 | 08/05 | 5 1 689239 | 8.22 | TN | 22350 | 00004 | 3 | |||
23 | 08/12 | 6 1 608162 | 7.96 | TN | 22350 | 00004 | 3 | |||
24 | 08/12 | 7 1 608162 | 4.03 | TN | 22350 | 00004 | 1 | |||
25 | 08/19 | 2 1 600021 | 8.54 | TN | 22350 | 00004 | 3 | |||
26 | 08/19 | 3 1 600021 | 3.26 | TN | 22350 | 00004 | 1 | |||
27 | 08/26 | 1 1 690026 | 3.36 | TN | 22350 | 00004 | 3 | |||
28 | 08/26 | 2 1 690026 | 9.82 | TN | 22350 | 00004 | 1 | |||
29 | 09/01 | 5 1 600021 | 7.42 | TN | 22350 | 00004 | 1 | |||
Sheet1 |
=SUMPRODUCT((MONTH(Sheet1!$A$3:$A$54)=6)*(Sheet1!$F$3:$F$54=Tonnage!D30*1)*(Sheet1!$H$3:$H$54=RIGHT(Tonnage!E30,1)))
Need all the months = 6
account to be a number so *1
look at the group, mine has combined info so take the right 1 character
What am I missing?