Using OFFSET, SUMPRODUCT & LEFT in a formula

1629dill

New Member
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
CUSTNOCUSNAMPARTDESCDATESHIFTPRESSHOURSRSTDPCSACTPCSWONO
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/01/20191B058464612167844
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/01/20192B058464408167844
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/01/20193B058464510167844
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/02/20191B058464510167844
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/02/20192B058464306167844
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/02/20193B058464510167844
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/04/20191B058464306167844
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/04/20192B058464408167844
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/04/20193B058464510167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/05/20191B058464408167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/05/20192B058464408167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/05/20193B058464510167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/06/20191B058464510167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/06/20192B058464408167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/06/20193B058464510167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/07/20191B058464510167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/07/20192B058464204167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/07/20193B058464408167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/08/20191B058464510167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/08/20192B058464510167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/08/20193B058464510167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/08/20199B0500102167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/11/20191B058464408167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/11/20192B058464306167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/11/20193B058464510167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/12/20191B0542320167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/12/20191B054232408167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/12/20192B058464408167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/12/20193B058464510167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/13/20191B058464612167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/13/20192B058464408167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/13/20193B058464510167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/14/20191B058464510167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/14/20192B058464306167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/14/20193B058464408167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/15/20191B058464612167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/15/20192B058464306167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/15/20193B058464612167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/16/20191B058464510167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/16/20192B058464408167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/16/20193B058464612167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/18/20199B0500102167845
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/18/20191B058464306167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/18/20192B058464510167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/18/20193B058464510167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/19/20191B054232204167846
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/19/20191B054232306167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/19/20192B058464408167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/19/20193B058464510167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/20/20191B058464510167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/20/20192B058464408167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/20/20193B058464510167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/21/20191B058464408167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/21/20192B058464510167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/21/20193B058464612167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/22/20191B058464510167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/22/20192B058464510167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/22/20193B058464510167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/23/20191B058464510167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/23/20192B058464510167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/23/20193B057406510167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/25/20191B058464306167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/25/20192B058464408167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/25/20193B058464510167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/26/20191B053174204167847
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/26/20191B055290408167848
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/26/20192B058464510167848
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/26/20193B058464510167848
34001CORTINA SAFETY PRODUCTS03-734DELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS03/27/20191B055290306167848
34001CORTINA SAFETY PRODUCTS03-734CDELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT BOTTOM03/27/20191B053174204167849
34001CORTINA SAFETY PRODUCTS03-734CDELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT BOTTOM03/27/20192B058464510167849
34001CORTINA SAFETY PRODUCTS03-734CDELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT BOTTOM03/27/20193B058464510167849
34001CORTINA SAFETY PRODUCTS03-734CDELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT BOTTOM03/28/20191B0500174167849
34001CORTINA SAFETY PRODUCTS03-734OTDELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT HANDLE03/28/20191B058464306167360
34001CORTINA SAFETY PRODUCTS03-734OTDELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT HANDLE03/28/20192B058464510167360
34001CORTINA SAFETY PRODUCTS03-734OTDELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT HANDLE03/28/20193B058464612167360
34001CORTINA SAFETY PRODUCTS03-734OTDELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT HANDLE03/29/20191B058464306167360
34001CORTINA SAFETY PRODUCTS03-734OTDELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT HANDLE03/29/20192B058464408167360
34001CORTINA SAFETY PRODUCTS03-734OTDELINEATOR POST FLARED 42"W/2 3"H.I.COLLARS CUT HANDLE03/29/20193B057.5435510167360
34001CORTINA SAFETY PRODUCTS03-750B42" CHANNELIZER POST PLAIN BLUE03/01/20192B0182560167750
34001CORTINA SAFETY PRODUCTS03-750B42" CHANNELIZER POST PLAIN BLUE03/01/20193B018256336167750
34001CORTINA SAFETY PRODUCTS03-750B42" CHANNELIZER POST PLAIN BLUE03/04/20191B015160107167750
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/01/20191B018256168167751
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/05/20193B016.52080167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/06/20191B018256336167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/06/20192B018256336167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/06/20193B018256168167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/07/20191B018256336167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/07/20192B018256168167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/07/20193B018256168167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/08/20191B018256336167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/08/20192B018256336167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/08/20193B018256168167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/11/20191B018256168167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/11/20192B018256168167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/11/20193B018256336167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/12/20191B018256168167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/12/20192B028256336167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/12/20193B018256168167957
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/12/20193B0100168167958
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/13/20191B018256336167958
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/13/20192B018256168167958
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/13/20193B018256336167958
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/14/20191B018256336167958
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/14/20192B018256336167958
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/15/20191B018256168167958
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/15/20192B018256168167958
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/15/20193B018256434167958
34001CORTINA SAFETY PRODUCTS03-750O42" CHANNELIZER POST PLAIN03/15/20199B0100336167958
34001CORTINA SAFETY PRODUCTS03-750U42" CHANNELIZER POST PLAIN03/14/20193B018256336167959
34001CORTINA SAFETY PRODUCTS03-750U42" CHANNELIZER POST PLAIN03/18/20191B018256168167959
34001CORTINA SAFETY PRODUCTS03-750U42" CHANNELIZER POST PLAIN03/18/20192B018256168167959
34001CORTINA SAFETY PRODUCTS03-750U42" CHANNELIZER POST PLAIN03/19/20191B018256168167959
34001CORTINA SAFETY PRODUCTS03-750U42" CHANNELIZER POST PLAIN03/19/20192B018256168167959
34001CORTINA SAFETY PRODUCTS03-750U42" CHANNELIZER POST PLAIN03/19/20193B018256168167959
34001CORTINA SAFETY PRODUCTS03-750U42" CHANNELIZER POST PLAIN03/20/20191B016.52080167959
34001CORTINA SAFETY PRODUCTS03-750U42" CHANNELIZER POST PLAIN03/20/20192B01132168167959
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/01/20191B038368175167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/01/20192B038368315167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/01/20193B038368315167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/01/20199B030035167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/04/20191B038368175167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/04/20192B038368350167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/04/20193B038368315167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/05/20191B038368315167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/05/20192B038368350167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/05/20193B038368385167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/06/20191B038368350167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/06/20192B032920167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/06/20193B036276280167620
34001CORTINA SAFETY PRODUCTS03-756-PBLACK LOW PROFILE BARREL PLAIN03/07/20191B038368210167620
34001CORTINA SAFETY PRODUCTS03-76545" ROOFMOUNT ORANGE CHANNELIZER03/21/20191B011.5830168006
34001CORTINA SAFETY PRODUCTS03-76545" ROOFMOUNT ORANGE CHANNELIZER03/22/20192B018440336168006
34001CORTINA SAFETY PRODUCTS03-76545" ROOFMOUNT ORANGE CHANNELIZER03/22/20193B018440336168006
34001CORTINA SAFETY PRODUCTS03-76545" ROOFMOUNT ORANGE CHANNELIZER03/25/20191B017385168168006
34001CORTINA SAFETY PRODUCTS03-76545" ROOFMOUNT ORANGE CHANNELIZER03/25/20192B018440168168006
34001CORTINA SAFETY PRODUCTS03-76545" ROOFMOUNT ORANGE CHANNELIZER03/25/20193B018440336168006
34001CORTINA SAFETY PRODUCTS03-76545" ROOFMOUNT ORANGE CHANNELIZER03/26/20191B018440168168006
34001CORTINA SAFETY PRODUCTS03-76545" ROOFMOUNT ORANGE CHANNELIZER03/26/20192B018440336168006
34001CORTINA SAFETY PRODUCTS03-76545" ROOFMOUNT ORANGE CHANNELIZER03/26/20193B018440336168006
34001CORTINA SAFETY PRODUCTS03-76545" ROOFMOUNT ORANGE CHANNELIZER03/27/20191B018440336168006
74200RADIO FLYER INC13-103-012BMWWHITE #479 SEAT BACK03/18/20192B02823040167988
74200RADIO FLYER INC13-103-012BMWWHITE #479 SEAT BACK03/18/20193B02823040167988
74200RADIO FLYER INC13-103-012BMWWHITE #479 SEAT BACK03/19/20191B02823040167988
74200RADIO FLYER INC13-103-012BMWWHITE #479 SEAT BACK03/19/20192B02823040167988
74200RADIO FLYER INC13-103-012BMWWHITE #479 SEAT BACK03/19/20193B0282304500167988
74200RADIO FLYER INC13-103-012BMWWHITE #479 SEAT BACK03/20/20191B02823041000167988
74200RADIO FLYER INC13-103-012BMWWHITE #479 SEAT BACK03/20/20192B0200500167988
74200RADIO FLYER INC13-103-012BMWWHITE #479 SEAT BACK03/20/20193B02823041000167988
74200RADIO FLYER INC13-103-012BMWWHITE #479 SEAT BACK03/21/20191B02823041000167988
74200RADIO FLYER INC13-103-012BMWWHITE #479 SEAT BACK03/21/20192B0282304500167988
74200RADIO FLYER INC13-103-012BMWWHITE #479 SEAT BACK03/21/20193B026.51872500168114
74200RADIO FLYER INC13-103-014BMP479 FORK PINK03/29/20199B0300180168154
74200RADIO FLYER INC13-103-014BMP479 FORK PINK03/29/20199B0300190168155
74200RADIO FLYER INC13-103-014BMR479 FORK RED03/29/20199B0500150168182
74200RADIO FLYER INC13-103-014BMR479 FORK RED03/29/20199B0300180168183
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/13/20191B0352300167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/13/20192B038368240167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/13/20193B037322160167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/14/20191B03836880167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/18/20191B037322160167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/18/20192B034.52070167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/18/20193B038368160167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/19/20191B038368160167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/19/20192B038368560167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/19/20193B038368320167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/20/20191B038368320167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/20/20192B038368160167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/20/20193B038368320167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/21/20191B036.529980167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/21/20192B038368240167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/21/20193B03836880167991
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/21/20193B0300240168113
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/22/20191B0383680167993
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/22/20192B0383680167993
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/22/20193B038368400167993
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/25/20199B0300320167993
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/26/20191B038368160167993
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/26/20192B038368240167993
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/26/20193B038368240167993
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/27/20191B038368240167993
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/27/20192B038368240167993
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/27/20193B038368160167993
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/28/20191B037322320167993
74200RADIO FLYER INC13-103-018#479 FRONT WHEEL03/28/20192B0383680167993
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/13/20192B0300360167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/13/20193B0300120167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/14/20191B0300160167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/14/20199B0300160167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/18/20191B0300320167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/18/20192B0300320167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/18/20193B0300320167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/19/20191B0300320167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/19/20192B0300320167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/19/20193B0300640167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/20/20191B0300480167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/20/20192B0300320167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/20/20193B0300320167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/21/20191B0300160167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/21/20192B0300320167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/21/20193B0300480167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/22/20191B0200320167992
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/22/20193B0300160167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/25/20191B037644320167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/25/20192B038736480167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/25/20193B038736480167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/26/20191B0300320167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/26/20192B0300480167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/26/20193B0300480167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/27/20191B0300320167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/27/20192B0300480167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/27/20193B0300320167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/28/20191B0300320167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/28/20192B038736320167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/28/20193B038736160167994
74200RADIO FLYER INC13-103-019#479 REAR WHEEL03/28/20193B0300160168143
74200RADIO FLYER INC13-103-020BMP479 BODY PINK03/29/20199B030070168156
74200RADIO FLYER INC13-103-020BMP479 BODY PINK03/29/20199B030070168157
74200RADIO FLYER INC13-103-020BMP479 BODY PINK03/29/20199B030070168158
74200RADIO FLYER INC13-103-020BMP479 BODY PINK03/29/20199B030080168159
74200RADIO FLYER INC13-103-020BMP479 BODY PINK03/29/20199B030050168160
74200RADIO FLYER INC13-103-020BMP479 BODY PINK03/29/20199B030046168176
74200RADIO FLYER INC13-103-020BMR479 BODY RED03/29/20199B030070168184
74200RADIO FLYER INC13-103-020BMR479 BODY RED03/29/20199B030070168185
74200RADIO FLYER INC13-103-020BMR479 BODY RED03/29/20199B030080168186
74200RADIO FLYER INC99-103-108500 WHEEL03/06/20191B02823040167814
74200RADIO FLYER INC99-103-108500 WHEEL03/06/20192B02823042002167814
74200RADIO FLYER INC99-103-108500 WHEEL03/06/20193B02823042002167814
74200RADIO FLYER INC99-103-108500 WHEEL03/07/20191B02823041694167814
74200RADIO FLYER INC99-103-108500 WHEEL03/07/20192B025.51584308167814
74200RADIO FLYER INC99-103-108500 WHEEL03/07/20193B0272016924167814
74200RADIO FLYER INC99-103-108500 WHEEL03/08/20191B02823041848167814
74200RADIO FLYER INC99-103-108500 WHEEL03/08/20192B02823041238167814
74200RADIO FLYER INC99-103-108500 WHEEL03/08/20193B02823041540167814
74200RADIO FLYER INC99-103-108500 WHEEL03/11/20191B02823042002167814
74200RADIO FLYER INC99-103-108500 WHEEL03/11/20192B02823041232167814
74200RADIO FLYER INC99-103-108500 WHEEL03/11/20193B02823042002167814
74200RADIO FLYER INC99-103-108500 WHEEL03/12/20191B02514402310167814
74200RADIO FLYER INC99-103-108500 WHEEL03/12/20192B02823041540167814
74200RADIO FLYER INC99-103-108500 WHEEL03/12/20193B02823041848167814
74200RADIO FLYER INC99-103-108500 WHEEL03/13/20191B02823042002167814
74200RADIO FLYER INC99-103-108500 WHEEL03/13/20192B02823041078167814
74200RADIO FLYER INC99-103-108500 WHEEL03/13/20193B02823041848167814
74200RADIO FLYER INC99-103-108500 WHEEL03/14/20191B02002002167814
74200RADIO FLYER INC99-103-108500 WHEEL03/14/20192B0282304756167814
74200RADIO FLYER INC99-103-108500 WHEEL03/14/20193B02823042002167814
74200RADIO FLYER INC99-103-108500 WHEEL03/15/20191B02823041848167814
74200RADIO FLYER INC99-103-108500 WHEEL03/15/20192B02823042002167814
74200RADIO FLYER INC99-103-108500 WHEEL03/15/20193B02823041848167814
74200RADIO FLYER INC99-103-108500 WHEEL03/18/20191B0200924167814
74200RADIO FLYER INC99-103-108500 WHEEL03/18/20199B01000167814
74200RADIO FLYER INC99-103-108500 WHEEL03/18/20199B02001200167814
83100WEBER-STEPHEN PRODUCTS LLC99-116-05BIN CHARCOAL ASSY A/M SUM CHAR 1603/05/20191B0283600167712
83100WEBER-STEPHEN PRODUCTS LLC99-116-05BIN CHARCOAL ASSY A/M SUM CHAR 1603/05/20192B028360160167712
83100WEBER-STEPHEN PRODUCTS LLC99-116-05BIN CHARCOAL ASSY A/M SUM CHAR 1603/05/20193B027315109167712
83100WEBER-STEPHEN PRODUCTS LLC99-116-06BIN CHARCOAL PERF-0503/08/20191B038512270167278
83100WEBER-STEPHEN PRODUCTS LLC99-116-06BIN CHARCOAL PERF-0503/08/20192B0385120167278
83100WEBER-STEPHEN PRODUCTS LLC99-116-06BIN CHARCOAL PERF-0503/08/20193B038512900167278
83100WEBER-STEPHEN PRODUCTS LLC99-116-06BIN CHARCOAL PERF-0503/11/20191B034256180167278
83100WEBER-STEPHEN PRODUCTS LLC99-116-06BIN CHARCOAL PERF-0503/11/20192B038512540167278
83100WEBER-STEPHEN PRODUCTS LLC99-116-06BIN CHARCOAL PERF-0503/11/20193B038512360167278
83100WEBER-STEPHEN PRODUCTS LLC99-116-06BIN CHARCOAL PERF-0503/12/20191B038512180167278

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

pgc01

MrExcel MVP
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

New Member
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

MrExcel MVP
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.
 

Some videos you may like

This Week's Hot Topics

Top