Sumifs absolute

[Number1One]

Hi All,
Been trying to make this work with previous similar questions but unable to make it work.

When trying to do this on a summary level the absolute is done on the top level and not on the line by line level and then summed, which is what i am looking for

For example If i do a cross grid with my data set i get absolute error on Supplier C as 102 (P9+P18). Whereas on a summary level this comes back as 42(H15), -30+70. Only 1 issue on this example data set but much more on my actual data.

I have a few criteria, which are generally triggers in top left or what the summary/column is, Trying to keep the Date column search dynamic for minimum upkeep and analysis on 4 week/3 month periods. Formula in Summary currently: =SUMIFS(INDEX($G$21:$L$52,0,MATCH($B$2,$G$20:$L$20,0)),$A$21:$A$52,$B$5,$B$21:$B$52,$B$3,$D$21:$D$52,$B$4,$C$21:$C$52,$D13,$F$21:$F$52,E$12)

[TABLE="width: 979"]
<tbody>[TR]
[TD="colspan: 2, align: center"][TABLE="width: 1043"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="colspan: 2, align: center"]Triggers[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Date[/TD]
[TD]08/01/2019[/TD]
[TD="colspan: 2"]Summary[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Broken Down Check[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Data[/TD]
[TD]Z[/TD]
[TD]Total[/TD]
[TD]161[/TD]
[TD]206[/TD]
[TD]-45[/TD]
[TD]189[/TD]
[TD][/TD]
[TD]Total[/TD]
[TD]Total[/TD]
[TD]161[/TD]
[TD]206[/TD]
[TD]-45[/TD]
[TD]189[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Type[/TD]
[TD]Food[/TD]
[TD]Product[/TD]
[TD]Sales[/TD]
[TD]Forecast[/TD]
[TD]Error[/TD]
[TD]Abs Error[/TD]
[TD][/TD]
[TD]Product[/TD]
[TD]Supplier[/TD]
[TD]Sales[/TD]
[TD]Forecast[/TD]
[TD]Error[/TD]
[TD]Abs Error[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Check[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]72[/TD]
[TD]123[/TD]
[TD]-51[/TD]
[TD]51[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]28[/TD]
[TD]41[/TD]
[TD]-13[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]B[/TD]
[TD]21[/TD]
[TD]29[/TD]
[TD]-8[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]17[/TD]
[TD]83[/TD]
[TD]-66[/TD]
[TD]66[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]C[/TD]
[TD]23[/TD]
[TD]53[/TD]
[TD]-30[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]B[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD]72[/TD]
[TD]0[/TD]
[TD]72[/TD]
[TD]72[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]C[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD]Summary 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]E[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD]Total[/TD]
[TD]161[/TD]
[TD]206[/TD]
[TD]-45[/TD]
[TD]129[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]F[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD]Supplier[/TD]
[TD]Sales[/TD]
[TD]Forecast[/TD]
[TD]Error[/TD]
[TD]Abs Error[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]A[/TD]
[TD]17[/TD]
[TD]83[/TD]
[TD]-66[/TD]
[TD]66[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD]A[/TD]
[TD]45[/TD]
[TD]124[/TD]
[TD]-79[/TD]
[TD]79[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]A[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD]B[/TD]
[TD]21[/TD]
[TD]29[/TD]
[TD]-8[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD]C[/TD]
[TD]95[/TD]
[TD]53[/TD]
[TD]42[/TD]
[TD]42[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]C[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD][/TD]
[TD][/TD]
[TD]D[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]C[/TD]
[TD]72[/TD]
[TD]0[/TD]
[TD]72[/TD]
[TD]72[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][/TD]
[TD][/TD]
[TD]E[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]Data[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Check[/TD]
[TD]Data[/TD]
[TD]Supplier[/TD]
[TD]Type[/TD]
[TD]Product[/TD]
[TD]Metric[/TD]
[TD="align: right"]01/01/2019[/TD]
[TD="align: right"]08/01/2019[/TD]
[TD="align: right"]15/01/2019[/TD]
[TD="align: right"]22/01/2019[/TD]
[TD="align: right"]29/01/2019[/TD]
[TD="align: right"]05/02/2019[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD="align: right"]1[/TD]
[TD]Z[/TD]
[TD]A[/TD]
[TD]Food[/TD]
[TD="align: right"]1[/TD]
[TD]Sales[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]98[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD="align: right"]1[/TD]
[TD]Z[/TD]
[TD]A[/TD]
[TD]Food[/TD]
[TD="align: right"]1[/TD]
[TD]Forecast[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]88[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD="align: right"]1[/TD]
[TD]X[/TD]
[TD]A[/TD]
[TD]Food[/TD]
[TD="align: right"]1[/TD]
[TD]Sales[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]31[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD="align: right"]1[/TD]
[TD]X[/TD]
[TD]A[/TD]
[TD]Food[/TD]
[TD="align: right"]1[/TD]
[TD]Forecast[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]64[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]33[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD="align: right"]1[/TD]
[TD]Z[/TD]
[TD]B[/TD]
[TD]Food[/TD]
[TD="align: right"]1[/TD]
[TD]Sales[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]24[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD="align: right"]1[/TD]
[TD]Z[/TD]
[TD]B[/TD]
[TD]Food[/TD]
[TD="align: right"]1[/TD]
[TD]Forecast[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD="align: right"]1[/TD]
[TD]X[/TD]
[TD]B[/TD]
[TD]Food[/TD]
[TD="align: right"]1[/TD]
[TD]Sales[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]41[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD="align: right"]1[/TD]
[TD]X[/TD]
[TD]B[/TD]
[TD]Food[/TD]
[TD="align: right"]1[/TD]
[TD]Forecast[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]86[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]54[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[ValuationMan]

I'm not following exactly what your desired end result is, but I think I see something.

When I enter your formula in a workbook, the issue that jumps out to me is Criteria_range4 ($C$21:$C$52), and criteria4 ($D13). I'm pretty sure $D13 should be $C13.

 

[Number1One]

I'm not following exactly what your desired end result is, but I think I see something.

When I enter your formula in a workbook, the issue that jumps out to me is Criteria_range4 ($C$21:$C$52), and criteria4 ($D13). I'm pretty sure $D13 should be $C13.

Thanks, yeh thats my fault i didn't repost the formula after adding the 1234, abcd for guides.
Not sure how to Edit OP but here it is:
=SUMIFS(INDEX($H$22:$M$53,0,MATCH($C$3,$H$21:$M$21,0)),$B$22:$B$53,$C$6,$C$22:$C$53,$C$4,$E$22:$E$53,$C$5,$D$22:$D$53,$D14,$G$22:$G$53,E$13)

Goal is to get the correct Sum Absolute error, so i can use it in all my summaries automatically, rather than causing loads of calculations and then adding them up.
Currently its giving the wrong answer: Sum of all errors and then absoluting this answer.
Correct answer: Calculate absolute error per line of data and then sum it per summary triggers given.

Leaning toward some sort of sumproduct but it needs several conditions and not excessively resource heavy.

 

[Number1One]

The formula is from D14, Summary 2 as summary 2 shows the issue data: H16 should equal O8+O17
Similar formula in Summary 1 but different columns.

 

[ValuationMan]

I used the formula in D14 and I get 28, but your data shows 45. I assume 45 is wrong?

 

[Number1One]

45 is correct there its H16 where the answer is wrong.
Ah Your missing product 3, because the data got cut off:
[TABLE="width: 915"]
<colgroup><col><col><col><col><col span="3"><col><col><col span="4"></colgroup><tbody>[TR]
[TD]20[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]Check[/TD]
[TD]Data[/TD]
[TD]Supplier[/TD]
[TD]Type[/TD]
[TD]Product[/TD]
[TD]Metric[/TD]
[TD]01/01/2019[/TD]
[TD]08/01/2019[/TD]
[TD]15/01/2019[/TD]
[TD]22/01/2019[/TD]
[TD]29/01/2019[/TD]
[TD]05/02/2019[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]A[/TD]
[TD]Food[/TD]
[TD]1[/TD]
[TD]Sales[/TD]
[TD]93[/TD]
[TD]28[/TD]
[TD]76[/TD]
[TD]74[/TD]
[TD]4[/TD]
[TD]98[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]A[/TD]
[TD]Food[/TD]
[TD]1[/TD]
[TD]Forecast[/TD]
[TD]1[/TD]
[TD]41[/TD]
[TD]90[/TD]
[TD]45[/TD]
[TD]83[/TD]
[TD]88[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]1[/TD]
[TD]X[/TD]
[TD]A[/TD]
[TD]Food[/TD]
[TD]1[/TD]
[TD]Sales[/TD]
[TD]16[/TD]
[TD]52[/TD]
[TD]67[/TD]
[TD]25[/TD]
[TD]52[/TD]
[TD]31[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]1[/TD]
[TD]X[/TD]
[TD]A[/TD]
[TD]Food[/TD]
[TD]1[/TD]
[TD]Forecast[/TD]
[TD]41[/TD]
[TD]46[/TD]
[TD]64[/TD]
[TD]2[/TD]
[TD]76[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]B[/TD]
[TD]Food[/TD]
[TD]1[/TD]
[TD]Sales[/TD]
[TD]50[/TD]
[TD]21[/TD]
[TD]71[/TD]
[TD]31[/TD]
[TD]29[/TD]
[TD]24[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]B[/TD]
[TD]Food[/TD]
[TD]1[/TD]
[TD]Forecast[/TD]
[TD]19[/TD]
[TD]29[/TD]
[TD]92[/TD]
[TD]73[/TD]
[TD]55[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]1[/TD]
[TD]X[/TD]
[TD]B[/TD]
[TD]Food[/TD]
[TD]1[/TD]
[TD]Sales[/TD]
[TD]10[/TD]
[TD]50[/TD]
[TD]63[/TD]
[TD]56[/TD]
[TD]32[/TD]
[TD]41[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]1[/TD]
[TD]X[/TD]
[TD]B[/TD]
[TD]Food[/TD]
[TD]1[/TD]
[TD]Forecast[/TD]
[TD]10[/TD]
[TD]86[/TD]
[TD]48[/TD]
[TD]52[/TD]
[TD]25[/TD]
[TD]54[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]C[/TD]
[TD]Food[/TD]
[TD]1[/TD]
[TD]Sales[/TD]
[TD]77[/TD]
[TD]23[/TD]
[TD]11[/TD]
[TD]46[/TD]
[TD]77[/TD]
[TD]99[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]C[/TD]
[TD]Food[/TD]
[TD]1[/TD]
[TD]Forecast[/TD]
[TD]6[/TD]
[TD]53[/TD]
[TD]5[/TD]
[TD]22[/TD]
[TD]24[/TD]
[TD]51[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]B[/TD]
[TD]Packaging[/TD]
[TD]2[/TD]
[TD]Sales[/TD]
[TD]8[/TD]
[TD]56[/TD]
[TD]85[/TD]
[TD]39[/TD]
[TD]50[/TD]
[TD]89[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]B[/TD]
[TD]Packaging[/TD]
[TD]2[/TD]
[TD]Forecast[/TD]
[TD]87[/TD]
[TD]59[/TD]
[TD]29[/TD]
[TD]71[/TD]
[TD]93[/TD]
[TD]27[/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]C[/TD]
[TD]Packaging[/TD]
[TD]2[/TD]
[TD]Sales[/TD]
[TD]26[/TD]
[TD]20[/TD]
[TD]99[/TD]
[TD]95[/TD]
[TD]74[/TD]
[TD]47[/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]C[/TD]
[TD]Packaging[/TD]
[TD]2[/TD]
[TD]Forecast[/TD]
[TD]8[/TD]
[TD]42[/TD]
[TD]38[/TD]
[TD]92[/TD]
[TD]17[/TD]
[TD]77[/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD]1[/TD]
[TD]X[/TD]
[TD]C[/TD]
[TD]Packaging[/TD]
[TD]2[/TD]
[TD]Sales[/TD]
[TD]37[/TD]
[TD]95[/TD]
[TD]63[/TD]
[TD]4[/TD]
[TD]16[/TD]
[TD]28[/TD]
[/TR]
[TR]
[TD]37[/TD]
[TD]1[/TD]
[TD]X[/TD]
[TD]C[/TD]
[TD]Packaging[/TD]
[TD]2[/TD]
[TD]Forecast[/TD]
[TD]39[/TD]
[TD]79[/TD]
[TD]96[/TD]
[TD]92[/TD]
[TD]34[/TD]
[TD]52[/TD]
[/TR]
[TR]
[TD]38[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]E[/TD]
[TD]Packaging[/TD]
[TD]2[/TD]
[TD]Sales[/TD]
[TD]84[/TD]
[TD]30[/TD]
[TD]61[/TD]
[TD]81[/TD]
[TD]4[/TD]
[TD]99[/TD]
[/TR]
[TR]
[TD]39[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]E[/TD]
[TD]Packaging[/TD]
[TD]2[/TD]
[TD]Forecast[/TD]
[TD]95[/TD]
[TD]65[/TD]
[TD]31[/TD]
[TD]75[/TD]
[TD]3[/TD]
[TD]28[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]F[/TD]
[TD]Packaging[/TD]
[TD]2[/TD]
[TD]Sales[/TD]
[TD]35[/TD]
[TD]100[/TD]
[TD]92[/TD]
[TD]36[/TD]
[TD]50[/TD]
[TD]54[/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]F[/TD]
[TD]Packaging[/TD]
[TD]2[/TD]
[TD]Forecast[/TD]
[TD]77[/TD]
[TD]9[/TD]
[TD]76[/TD]
[TD]54[/TD]
[TD]14[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]42[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]A[/TD]
[TD]Food[/TD]
[TD]3[/TD]
[TD]Sales[/TD]
[TD]7[/TD]
[TD]17[/TD]
[TD]25[/TD]
[TD]81[/TD]
[TD]71[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]43[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]A[/TD]
[TD]Food[/TD]
[TD]3[/TD]
[TD]Forecast[/TD]
[TD]40[/TD]
[TD]83[/TD]
[TD]93[/TD]
[TD]79[/TD]
[TD]84[/TD]
[TD]73[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]0[/TD]
[TD]Z[/TD]
[TD]A[/TD]
[TD]Food[/TD]
[TD]4[/TD]
[TD]Sales[/TD]
[TD]19[/TD]
[TD]12[/TD]
[TD]76[/TD]
[TD]73[/TD]
[TD]41[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD]0[/TD]
[TD]Z[/TD]
[TD]A[/TD]
[TD]Food[/TD]
[TD]4[/TD]
[TD]Forecast[/TD]
[TD]45[/TD]
[TD]85[/TD]
[TD]43[/TD]
[TD]93[/TD]
[TD]48[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]46[/TD]
[TD]0[/TD]
[TD]Z[/TD]
[TD]B[/TD]
[TD]Food[/TD]
[TD]4[/TD]
[TD]Sales[/TD]
[TD]72[/TD]
[TD]19[/TD]
[TD]2[/TD]
[TD]24[/TD]
[TD]23[/TD]
[TD]84[/TD]
[/TR]
[TR]
[TD]47[/TD]
[TD]0[/TD]
[TD]Z[/TD]
[TD]B[/TD]
[TD]Food[/TD]
[TD]4[/TD]
[TD]Forecast[/TD]
[TD]43[/TD]
[TD]6[/TD]
[TD]60[/TD]
[TD]74[/TD]
[TD]37[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]48[/TD]
[TD]0[/TD]
[TD]Z[/TD]
[TD]C[/TD]
[TD]Food[/TD]
[TD]4[/TD]
[TD]Sales[/TD]
[TD]74[/TD]
[TD]63[/TD]
[TD]16[/TD]
[TD]87[/TD]
[TD]8[/TD]
[TD]76[/TD]
[/TR]
[TR]
[TD]49[/TD]
[TD]0[/TD]
[TD]Z[/TD]
[TD]C[/TD]
[TD]Food[/TD]
[TD]4[/TD]
[TD]Forecast[/TD]
[TD]85[/TD]
[TD]22[/TD]
[TD]24[/TD]
[TD]13[/TD]
[TD]72[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]C[/TD]
[TD]Food[/TD]
[TD]5[/TD]
[TD]Sales[/TD]
[TD]51[/TD]
[TD]72[/TD]
[TD]58[/TD]
[TD]80[/TD]
[TD]19[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]51[/TD]
[TD]1[/TD]
[TD]Z[/TD]
[TD]C[/TD]
[TD]Packaging[/TD]
[TD]5[/TD]
[TD]Forecast[/TD]
[TD]62[/TD]
[TD]23[/TD]
[TD]38[/TD]
[TD]41[/TD]
[TD]22[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]52[/TD]
[TD]1[/TD]
[TD]X[/TD]
[TD]C[/TD]
[TD]Packaging[/TD]
[TD]5[/TD]
[TD]Sales[/TD]
[TD]24[/TD]
[TD]41[/TD]
[TD]90[/TD]
[TD]48[/TD]
[TD]88[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]53[/TD]
[TD]1[/TD]
[TD]X[/TD]
[TD]C[/TD]
[TD]Packaging[/TD]
[TD]5[/TD]
[TD]Forecast[/TD]
[TD]34[/TD]
[TD]75[/TD]
[TD]12[/TD]
[TD]98[/TD]
[TD]77[/TD]
[TD]45[/TD]
[/TR]
</tbody>[/TABLE]

 

[Number1One]

Aware i didn't explain this very well in the first place, if anyone has any ideas on how to accomplish this or if there is more questions let me know.