Using OFFSET, SUMPRODUCT & LEFT in a formula

[1629dill]

I have created this formula to look at data that is coming from an AS400, to sum up, production hours.
I am getting a value error when I start using the if statement in the formula.

Without IF in ReportB4
=SUMPRODUCT(OFFSET(Table_Query_from_AS400_Data_1[[#Headers],[HOURSR]],1,0,COUNTA(Production_Data!$H:$H)),OFFSET(Table_Query_from_AS400_Data_1[[#Headers],[ACTPCS]],1,0,COUNTA(Production_Data!$J:$J)))/SUMPRODUCT(OFFSET(Table_Query_from_AS400_Data_1[[#Headers],[HOURSR]],1,0,COUNTA(Production_Data!$H:$H)),OFFSET(Table_Query_from_AS400_Data_1[[#Headers],[STDPCS]],1,0,COUNTA(Production_Data!$I:$I)))

With IF in ReportC4
=SUMPRODUCT(OFFSET(Table_Query_from_AS400_Data_1[[#Headers],[HOURSR]],1,0,COUNTA(Production_Data!$H:$H)),OFFSET(Table_Query_from_AS400_Data_1[[#Headers],[ACTPCS]],1,0,COUNTA(Production_Data!$J:$J)),IF(LEFT(OFFSET(Table_Query_from_AS400_Data_1[[#Headers],[PRESS]],1,0,COUNTA(Production_Data!$G:$G)),1)="B",1,0))/SUMPRODUCT(OFFSET(Table_Query_from_AS400_Data_1[[#Headers],[HOURSR]],1,0,COUNTA(Production_Data!$H:$H)),OFFSET(Table_Query_from_AS400_Data_1[[#Headers],[STDPCS]],1,0,COUNTA(Production_Data!$I:$I)))

Sample Data

CUSTNO	CUSNAM	PART	DESC	DATE	SHIFT	PRESS	HOURSR	STDPCS	ACTPCS	WONO
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/01/2019	1	B05	8	464	612	167844
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/01/2019	2	B05	8	464	408	167844
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/01/2019	3	B05	8	464	510	167844
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/02/2019	1	B05	8	464	510	167844
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/02/2019	2	B05	8	464	306	167844
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/02/2019	3	B05	8	464	510	167844
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/04/2019	1	B05	8	464	306	167844
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/04/2019	2	B05	8	464	408	167844
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/04/2019	3	B05	8	464	510	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/05/2019	1	B05	8	464	408	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/05/2019	2	B05	8	464	408	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/05/2019	3	B05	8	464	510	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/06/2019	1	B05	8	464	510	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/06/2019	2	B05	8	464	408	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/06/2019	3	B05	8	464	510	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/07/2019	1	B05	8	464	510	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/07/2019	2	B05	8	464	204	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/07/2019	3	B05	8	464	408	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/08/2019	1	B05	8	464	510	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/08/2019	2	B05	8	464	510	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/08/2019	3	B05	8	464	510	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/08/2019	9	B05	0	0	102	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/11/2019	1	B05	8	464	408	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/11/2019	2	B05	8	464	306	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/11/2019	3	B05	8	464	510	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/12/2019	1	B05	4	232	0	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/12/2019	1	B05	4	232	408	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/12/2019	2	B05	8	464	408	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/12/2019	3	B05	8	464	510	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/13/2019	1	B05	8	464	612	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/13/2019	2	B05	8	464	408	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/13/2019	3	B05	8	464	510	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/14/2019	1	B05	8	464	510	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/14/2019	2	B05	8	464	306	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/14/2019	3	B05	8	464	408	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/15/2019	1	B05	8	464	612	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/15/2019	2	B05	8	464	306	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/15/2019	3	B05	8	464	612	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/16/2019	1	B05	8	464	510	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/16/2019	2	B05	8	464	408	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/16/2019	3	B05	8	464	612	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/18/2019	9	B05	0	0	102	167845
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/18/2019	1	B05	8	464	306	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/18/2019	2	B05	8	464	510	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/18/2019	3	B05	8	464	510	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/19/2019	1	B05	4	232	204	167846
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/19/2019	1	B05	4	232	306	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/19/2019	2	B05	8	464	408	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/19/2019	3	B05	8	464	510	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/20/2019	1	B05	8	464	510	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/20/2019	2	B05	8	464	408	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/20/2019	3	B05	8	464	510	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/21/2019	1	B05	8	464	408	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/21/2019	2	B05	8	464	510	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/21/2019	3	B05	8	464	612	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/22/2019	1	B05	8	464	510	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/22/2019	2	B05	8	464	510	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/22/2019	3	B05	8	464	510	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/23/2019	1	B05	8	464	510	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/23/2019	2	B05	8	464	510	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/23/2019	3	B05	7	406	510	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/25/2019	1	B05	8	464	306	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/25/2019	2	B05	8	464	408	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/25/2019	3	B05	8	464	510	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/26/2019	1	B05	3	174	204	167847
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/26/2019	1	B05	5	290	408	167848
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/26/2019	2	B05	8	464	510	167848
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/26/2019	3	B05	8	464	510	167848
34001	CORTINA SAFETY PRODUCTS	03-734	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS	03/27/2019	1	B05	5	290	306	167848
34001	CORTINA SAFETY PRODUCTS	03-734C	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT BOTTOM	03/27/2019	1	B05	3	174	204	167849
34001	CORTINA SAFETY PRODUCTS	03-734C	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT BOTTOM	03/27/2019	2	B05	8	464	510	167849
34001	CORTINA SAFETY PRODUCTS	03-734C	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT BOTTOM	03/27/2019	3	B05	8	464	510	167849
34001	CORTINA SAFETY PRODUCTS	03-734C	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT BOTTOM	03/28/2019	1	B05	0	0	174	167849
34001	CORTINA SAFETY PRODUCTS	03-734OT	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT HANDLE	03/28/2019	1	B05	8	464	306	167360
34001	CORTINA SAFETY PRODUCTS	03-734OT	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT HANDLE	03/28/2019	2	B05	8	464	510	167360
34001	CORTINA SAFETY PRODUCTS	03-734OT	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT HANDLE	03/28/2019	3	B05	8	464	612	167360
34001	CORTINA SAFETY PRODUCTS	03-734OT	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT HANDLE	03/29/2019	1	B05	8	464	306	167360
34001	CORTINA SAFETY PRODUCTS	03-734OT	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT HANDLE	03/29/2019	2	B05	8	464	408	167360
34001	CORTINA SAFETY PRODUCTS	03-734OT	DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT HANDLE	03/29/2019	3	B05	7.5	435	510	167360
34001	CORTINA SAFETY PRODUCTS	03-750B	42" CHANNELIZER POST PLAIN BLUE	03/01/2019	2	B01	8	256	0	167750
34001	CORTINA SAFETY PRODUCTS	03-750B	42" CHANNELIZER POST PLAIN BLUE	03/01/2019	3	B01	8	256	336	167750
34001	CORTINA SAFETY PRODUCTS	03-750B	42" CHANNELIZER POST PLAIN BLUE	03/04/2019	1	B01	5	160	107	167750
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/01/2019	1	B01	8	256	168	167751
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/05/2019	3	B01	6.5	208	0	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/06/2019	1	B01	8	256	336	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/06/2019	2	B01	8	256	336	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/06/2019	3	B01	8	256	168	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/07/2019	1	B01	8	256	336	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/07/2019	2	B01	8	256	168	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/07/2019	3	B01	8	256	168	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/08/2019	1	B01	8	256	336	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/08/2019	2	B01	8	256	336	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/08/2019	3	B01	8	256	168	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/11/2019	1	B01	8	256	168	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/11/2019	2	B01	8	256	168	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/11/2019	3	B01	8	256	336	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/12/2019	1	B01	8	256	168	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/12/2019	2	B02	8	256	336	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/12/2019	3	B01	8	256	168	167957
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/12/2019	3	B01	0	0	168	167958
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/13/2019	1	B01	8	256	336	167958
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/13/2019	2	B01	8	256	168	167958
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/13/2019	3	B01	8	256	336	167958
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/14/2019	1	B01	8	256	336	167958
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/14/2019	2	B01	8	256	336	167958
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/15/2019	1	B01	8	256	168	167958
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/15/2019	2	B01	8	256	168	167958
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/15/2019	3	B01	8	256	434	167958
34001	CORTINA SAFETY PRODUCTS	03-750O	42" CHANNELIZER POST PLAIN	03/15/2019	9	B01	0	0	336	167958
34001	CORTINA SAFETY PRODUCTS	03-750U	42" CHANNELIZER POST PLAIN	03/14/2019	3	B01	8	256	336	167959
34001	CORTINA SAFETY PRODUCTS	03-750U	42" CHANNELIZER POST PLAIN	03/18/2019	1	B01	8	256	168	167959
34001	CORTINA SAFETY PRODUCTS	03-750U	42" CHANNELIZER POST PLAIN	03/18/2019	2	B01	8	256	168	167959
34001	CORTINA SAFETY PRODUCTS	03-750U	42" CHANNELIZER POST PLAIN	03/19/2019	1	B01	8	256	168	167959
34001	CORTINA SAFETY PRODUCTS	03-750U	42" CHANNELIZER POST PLAIN	03/19/2019	2	B01	8	256	168	167959
34001	CORTINA SAFETY PRODUCTS	03-750U	42" CHANNELIZER POST PLAIN	03/19/2019	3	B01	8	256	168	167959
34001	CORTINA SAFETY PRODUCTS	03-750U	42" CHANNELIZER POST PLAIN	03/20/2019	1	B01	6.5	208	0	167959
34001	CORTINA SAFETY PRODUCTS	03-750U	42" CHANNELIZER POST PLAIN	03/20/2019	2	B01	1	32	168	167959
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/01/2019	1	B03	8	368	175	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/01/2019	2	B03	8	368	315	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/01/2019	3	B03	8	368	315	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/01/2019	9	B03	0	0	35	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/04/2019	1	B03	8	368	175	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/04/2019	2	B03	8	368	350	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/04/2019	3	B03	8	368	315	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/05/2019	1	B03	8	368	315	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/05/2019	2	B03	8	368	350	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/05/2019	3	B03	8	368	385	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/06/2019	1	B03	8	368	350	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/06/2019	2	B03	2	92	0	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/06/2019	3	B03	6	276	280	167620
34001	CORTINA SAFETY PRODUCTS	03-756-P	BLACK LOW PROFILE BARREL PLAIN	03/07/2019	1	B03	8	368	210	167620
34001	CORTINA SAFETY PRODUCTS	03-765	45" ROOFMOUNT ORANGE CHANNELIZER	03/21/2019	1	B01	1.5	83	0	168006
34001	CORTINA SAFETY PRODUCTS	03-765	45" ROOFMOUNT ORANGE CHANNELIZER	03/22/2019	2	B01	8	440	336	168006
34001	CORTINA SAFETY PRODUCTS	03-765	45" ROOFMOUNT ORANGE CHANNELIZER	03/22/2019	3	B01	8	440	336	168006
34001	CORTINA SAFETY PRODUCTS	03-765	45" ROOFMOUNT ORANGE CHANNELIZER	03/25/2019	1	B01	7	385	168	168006
34001	CORTINA SAFETY PRODUCTS	03-765	45" ROOFMOUNT ORANGE CHANNELIZER	03/25/2019	2	B01	8	440	168	168006
34001	CORTINA SAFETY PRODUCTS	03-765	45" ROOFMOUNT ORANGE CHANNELIZER	03/25/2019	3	B01	8	440	336	168006
34001	CORTINA SAFETY PRODUCTS	03-765	45" ROOFMOUNT ORANGE CHANNELIZER	03/26/2019	1	B01	8	440	168	168006
34001	CORTINA SAFETY PRODUCTS	03-765	45" ROOFMOUNT ORANGE CHANNELIZER	03/26/2019	2	B01	8	440	336	168006
34001	CORTINA SAFETY PRODUCTS	03-765	45" ROOFMOUNT ORANGE CHANNELIZER	03/26/2019	3	B01	8	440	336	168006
34001	CORTINA SAFETY PRODUCTS	03-765	45" ROOFMOUNT ORANGE CHANNELIZER	03/27/2019	1	B01	8	440	336	168006
74200	RADIO FLYER INC	13-103-012BMW	WHITE #479 SEAT BACK	03/18/2019	2	B02	8	2304	0	167988
74200	RADIO FLYER INC	13-103-012BMW	WHITE #479 SEAT BACK	03/18/2019	3	B02	8	2304	0	167988
74200	RADIO FLYER INC	13-103-012BMW	WHITE #479 SEAT BACK	03/19/2019	1	B02	8	2304	0	167988
74200	RADIO FLYER INC	13-103-012BMW	WHITE #479 SEAT BACK	03/19/2019	2	B02	8	2304	0	167988
74200	RADIO FLYER INC	13-103-012BMW	WHITE #479 SEAT BACK	03/19/2019	3	B02	8	2304	500	167988
74200	RADIO FLYER INC	13-103-012BMW	WHITE #479 SEAT BACK	03/20/2019	1	B02	8	2304	1000	167988
74200	RADIO FLYER INC	13-103-012BMW	WHITE #479 SEAT BACK	03/20/2019	2	B02	0	0	500	167988
74200	RADIO FLYER INC	13-103-012BMW	WHITE #479 SEAT BACK	03/20/2019	3	B02	8	2304	1000	167988
74200	RADIO FLYER INC	13-103-012BMW	WHITE #479 SEAT BACK	03/21/2019	1	B02	8	2304	1000	167988
74200	RADIO FLYER INC	13-103-012BMW	WHITE #479 SEAT BACK	03/21/2019	2	B02	8	2304	500	167988
74200	RADIO FLYER INC	13-103-012BMW	WHITE #479 SEAT BACK	03/21/2019	3	B02	6.5	1872	500	168114
74200	RADIO FLYER INC	13-103-014BMP	479 FORK PINK	03/29/2019	9	B03	0	0	180	168154
74200	RADIO FLYER INC	13-103-014BMP	479 FORK PINK	03/29/2019	9	B03	0	0	190	168155
74200	RADIO FLYER INC	13-103-014BMR	479 FORK RED	03/29/2019	9	B05	0	0	150	168182
74200	RADIO FLYER INC	13-103-014BMR	479 FORK RED	03/29/2019	9	B03	0	0	180	168183
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/13/2019	1	B03	5	230	0	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/13/2019	2	B03	8	368	240	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/13/2019	3	B03	7	322	160	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/14/2019	1	B03	8	368	80	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/18/2019	1	B03	7	322	160	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/18/2019	2	B03	4.5	207	0	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/18/2019	3	B03	8	368	160	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/19/2019	1	B03	8	368	160	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/19/2019	2	B03	8	368	560	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/19/2019	3	B03	8	368	320	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/20/2019	1	B03	8	368	320	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/20/2019	2	B03	8	368	160	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/20/2019	3	B03	8	368	320	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/21/2019	1	B03	6.5	299	80	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/21/2019	2	B03	8	368	240	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/21/2019	3	B03	8	368	80	167991
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/21/2019	3	B03	0	0	240	168113
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/22/2019	1	B03	8	368	0	167993
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/22/2019	2	B03	8	368	0	167993
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/22/2019	3	B03	8	368	400	167993
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/25/2019	9	B03	0	0	320	167993
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/26/2019	1	B03	8	368	160	167993
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/26/2019	2	B03	8	368	240	167993
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/26/2019	3	B03	8	368	240	167993
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/27/2019	1	B03	8	368	240	167993
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/27/2019	2	B03	8	368	240	167993
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/27/2019	3	B03	8	368	160	167993
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/28/2019	1	B03	7	322	320	167993
74200	RADIO FLYER INC	13-103-018	#479 FRONT WHEEL	03/28/2019	2	B03	8	368	0	167993
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/13/2019	2	B03	0	0	360	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/13/2019	3	B03	0	0	120	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/14/2019	1	B03	0	0	160	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/14/2019	9	B03	0	0	160	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/18/2019	1	B03	0	0	320	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/18/2019	2	B03	0	0	320	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/18/2019	3	B03	0	0	320	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/19/2019	1	B03	0	0	320	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/19/2019	2	B03	0	0	320	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/19/2019	3	B03	0	0	640	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/20/2019	1	B03	0	0	480	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/20/2019	2	B03	0	0	320	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/20/2019	3	B03	0	0	320	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/21/2019	1	B03	0	0	160	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/21/2019	2	B03	0	0	320	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/21/2019	3	B03	0	0	480	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/22/2019	1	B02	0	0	320	167992
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/22/2019	3	B03	0	0	160	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/25/2019	1	B03	7	644	320	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/25/2019	2	B03	8	736	480	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/25/2019	3	B03	8	736	480	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/26/2019	1	B03	0	0	320	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/26/2019	2	B03	0	0	480	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/26/2019	3	B03	0	0	480	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/27/2019	1	B03	0	0	320	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/27/2019	2	B03	0	0	480	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/27/2019	3	B03	0	0	320	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/28/2019	1	B03	0	0	320	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/28/2019	2	B03	8	736	320	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/28/2019	3	B03	8	736	160	167994
74200	RADIO FLYER INC	13-103-019	#479 REAR WHEEL	03/28/2019	3	B03	0	0	160	168143
74200	RADIO FLYER INC	13-103-020BMP	479 BODY PINK	03/29/2019	9	B03	0	0	70	168156
74200	RADIO FLYER INC	13-103-020BMP	479 BODY PINK	03/29/2019	9	B03	0	0	70	168157
74200	RADIO FLYER INC	13-103-020BMP	479 BODY PINK	03/29/2019	9	B03	0	0	70	168158
74200	RADIO FLYER INC	13-103-020BMP	479 BODY PINK	03/29/2019	9	B03	0	0	80	168159
74200	RADIO FLYER INC	13-103-020BMP	479 BODY PINK	03/29/2019	9	B03	0	0	50	168160
74200	RADIO FLYER INC	13-103-020BMP	479 BODY PINK	03/29/2019	9	B03	0	0	46	168176
74200	RADIO FLYER INC	13-103-020BMR	479 BODY RED	03/29/2019	9	B03	0	0	70	168184
74200	RADIO FLYER INC	13-103-020BMR	479 BODY RED	03/29/2019	9	B03	0	0	70	168185
74200	RADIO FLYER INC	13-103-020BMR	479 BODY RED	03/29/2019	9	B03	0	0	80	168186
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/06/2019	1	B02	8	2304	0	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/06/2019	2	B02	8	2304	2002	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/06/2019	3	B02	8	2304	2002	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/07/2019	1	B02	8	2304	1694	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/07/2019	2	B02	5.5	1584	308	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/07/2019	3	B02	7	2016	924	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/08/2019	1	B02	8	2304	1848	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/08/2019	2	B02	8	2304	1238	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/08/2019	3	B02	8	2304	1540	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/11/2019	1	B02	8	2304	2002	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/11/2019	2	B02	8	2304	1232	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/11/2019	3	B02	8	2304	2002	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/12/2019	1	B02	5	1440	2310	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/12/2019	2	B02	8	2304	1540	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/12/2019	3	B02	8	2304	1848	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/13/2019	1	B02	8	2304	2002	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/13/2019	2	B02	8	2304	1078	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/13/2019	3	B02	8	2304	1848	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/14/2019	1	B02	0	0	2002	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/14/2019	2	B02	8	2304	756	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/14/2019	3	B02	8	2304	2002	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/15/2019	1	B02	8	2304	1848	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/15/2019	2	B02	8	2304	2002	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/15/2019	3	B02	8	2304	1848	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/18/2019	1	B02	0	0	924	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/18/2019	9	B01	0	0	0	167814
74200	RADIO FLYER INC	99-103-108	500 WHEEL	03/18/2019	9	B02	0	0	1200	167814
83100	WEBER-STEPHEN PRODUCTS LLC	99-116-05	BIN CHARCOAL ASSY A/M SUM CHAR 16	03/05/2019	1	B02	8	360	0	167712
83100	WEBER-STEPHEN PRODUCTS LLC	99-116-05	BIN CHARCOAL ASSY A/M SUM CHAR 16	03/05/2019	2	B02	8	360	160	167712
83100	WEBER-STEPHEN PRODUCTS LLC	99-116-05	BIN CHARCOAL ASSY A/M SUM CHAR 16	03/05/2019	3	B02	7	315	109	167712
83100	WEBER-STEPHEN PRODUCTS LLC	99-116-06	BIN CHARCOAL PERF-05	03/08/2019	1	B03	8	512	270	167278
83100	WEBER-STEPHEN PRODUCTS LLC	99-116-06	BIN CHARCOAL PERF-05	03/08/2019	2	B03	8	512	0	167278
83100	WEBER-STEPHEN PRODUCTS LLC	99-116-06	BIN CHARCOAL PERF-05	03/08/2019	3	B03	8	512	900	167278
83100	WEBER-STEPHEN PRODUCTS LLC	99-116-06	BIN CHARCOAL PERF-05	03/11/2019	1	B03	4	256	180	167278
83100	WEBER-STEPHEN PRODUCTS LLC	99-116-06	BIN CHARCOAL PERF-05	03/11/2019	2	B03	8	512	540	167278
83100	WEBER-STEPHEN PRODUCTS LLC	99-116-06	BIN CHARCOAL PERF-05	03/11/2019	3	B03	8	512	360	167278
83100	WEBER-STEPHEN PRODUCTS LLC	99-116-06	BIN CHARCOAL PERF-05	03/12/2019	1	B03	8	512	180	167278

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[pgc01]

Hi

I can see 2 possible problems.

1 - This is an array formula. Did you confirm it with CTRL-SHIFT-ENTER?

2 - all the ranges in the parameters of the SumProduct() must have the same dimensions.
Confirm that COUNTA(Production_Data!$G:$G), COUNTA(Production_Data!$H:$H), COUNTA(Production_Data!$I:$I), COUNTA(Production_Data!$J:$J) all yield the same result.

 

[1629dill]

The CTRL-SHIFT-ENTER worked.

Thanks

Hi

I can see 2 possible problems.

1 - This is an array formula. Did you confirm it with CTRL-SHIFT-ENTER?

2 - all the ranges in the parameters of the SumProduct() must have the same dimensions.
Confirm that COUNTA(Production_Data!$G:$G), COUNTA(Production_Data!$H:$H), COUNTA(Production_Data!$I:$I), COUNTA(Production_Data!$J:$J) all yield the same result.

 

[pgc01]

That's good.

You can also try to replace

IF(LEFT(OFFSET(Table_Query_from_AS400_Data_1[[#Headers];[PRESS]];1;0;COUNTA(Production_Data!$G:$G));1)="B";1;0)

with

--(LEFT(OFFSET(Table_Query_from_AS400_Data_1[[#Headers];[PRESS]];1;0;COUNTA(Production_Data!$G:$G));1)="B")

In this case you would simply confirm with ENTER as usual.