Sumifs absolute

Number1One

New Member
Joined
Mar 1, 2019
Messages
16
Office Version
  1. 365
Platform
  1. Windows
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]
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
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.
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
I used the formula in D14 and I get 28, but your data shows 45. I assume 45 is wrong?
 
Upvote 0
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]
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,224,315
Messages
6,177,845
Members
452,810
Latest member
jeffrey0409

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top