Count with sumproduct

[texasalynn]

Ok I know I've done these before, but I must be off in Neverland.

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?

 

[Oaktree]

Hi, texasalynn.

Are the values in column H text or numbers? You may need RIGHT(Tonnage!E30,1)*1 in your formula if they're numbers.

 

[texasalynn]

THANKS Oaktree! that was it, knew I must be staring at it.

Have a wonderful Christmas