Spreadsheet: 598863d1542751727-understanding-what-this-formula-is-doing-in-laymans-terms-example-sheet
Sheet: Data

Column 1 | IMA_ItemID | Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals
Apple2011 | Apple | 2011 | 9 | 27 | 52 | 57 | 99 | 99 | 106 | 56 | 34 | 16 | 14 | 73 | 642
Apple2012 | Apple | 2012 | 65 | 6 | 56 | 98 | 75 | 66 | 87 | 55 | 24 | 33 | 12 | 89 | 666
Apple2013 | Apple | 2013 | 50 | 28 | 22 | 45 | 56 | 73 | 51 | 83 | 26 | 48 | 9 | 116 | 607
Apple2014 | Apple | 2014 | 20 | 15 | 35 | 59 | 69 | 53 | 98 | 59 | 53 | 22 | 13 | 107 | 603
Apple2015 | Apple | 2015 | 14 | 16 | 54 | 50 | 69 | 41 | 88 | 51 | 48 | 20 | 20 | 122 | 593
Apple2016 | Apple | 2016 | 33 | 16 | 51 | 51 | 62 | 95 | 34 | 63 | 39 | 21 | 12 | 68 | 545
Apple2017 | Apple | 2017 | 21 | 22 | 57 | 61 | 68 | 60 | 75 | 88 | 12 | 28 |  |  | 492
Banana2011 | [NAME] | 2011 | 14 | 15 | 17 | 15 | 24 | 19 | 16 | 20 | 9 | 2 |  | 18 | 169
Banana2012 | [NAME] | 2012 | 30 | 2 | 7 | 9 | 20 | 19 | 30 | 10 | 19 | 7 | 11 | 21 | 185
Banana2013 | [NAME] | 2013 | 10 | 13 | 14 | 17 | 19 | 26 | 21 | 17 | 17 | 17 | 9 | 31 | 211
Banana2014 | [NAME] | 2014 | 13 | 1 | 19 | 16 | 26 | 20 | 35 | 30 | 8 | 22 | 4 | 31 | 225
Banana2015 | [NAME] | 2015 | 4 | 17 | 16 | 18 | 25 | 29 | 19 | 23 | 30 | 20 | 3 | 32 | 236
Banana2016 | [NAME] | 2016 | 14 | 14 | 22 | 37 | 28 | 54 | 46 | 25 | 27 | 18 | 5 | 27 | 317
Banana2017 | [NAME] | 2017 | 16 | 13 | 21 | 34 | 31 | 30 | 28 | 44 | 20 | 8 |  |  | 245
Grape2011 | Grape | 2011 | 17 | 30 | 61 | 55 | 64 | 102 | 82 | 72 | 27 | 13 | 12 | 76 | 611
Grape2012 | Grape | 2012 | 28 | 9 | 60 | 101 | 84 | 66 | 61 | 33 | 24 | 26 | 22 | 74 | 588
[NAME] | Grape | 2013 | 48 | 27 | 46 | 68 | 93 | 51 | 56 | 64 | 31 | 37 | 2 | 118 | 641
Grape2014 | Grape | 2014 | 26 | 23 | 50 | 78 | 42 | 98 | 67 | 49 | 52 | 42 | 10 | 68 | 605
Grape2015 | Grape | 2015 | 16 | 28 | 67 | 83 | 82 | 58 | 85 | 51 | 41 | 15 | 8 | 156 | 690
[NAME] | Grape | 2016 | 26 | 13 | 63 | 73 | 84 | 70 | 52 | 39 | 28 | 29 | 21 | 43 | 541
Grape2017 | Grape | 2017 | 15 | 36 | 43 | 66 | 76 | 93 | 67 | 54 | 36 | 21 |  |  | 507
Orange2011 | Orange | 2011 | 9 | 4 | 16 | 12 | 22 | 51 | 30 | 21 | 6 | 14 | 12 | 31 | 228
Orange2012 | Orange | 2012 | 24 | 6 | 8 | 42 | 39 | 23 | 24 | 25 | 11 | 7 |  | 23 | 232
Orange2013 | Orange | 2013 | 15 | 12 | 13 | 32 | 20 | 23 | 36 | 30 | 11 | 26 | 9 | 58 | 285
Orange2014 | Orange | 2014 | 23 |  | 26 | 29 | 28 | 28 | 37 | 32 | 17 | 13 | 11 | 39 | 283
Orange2015 | Orange | 2015 | 11 | 14 | 32 | 40 | 30 | 28 | 34 | 8 | 24 | 9 | 10 | 33 | 273
Orange2016 | Orange | 2016 | 12 | 9 | 43 | 28 | 39 | 30 | 39 | 21 | 24 | 9 | 9 | 41 | 304
Orange2017 | Orange | 2017 | 19 | 9 | 20 | 20 | 47 | 25 | 24 | 39 | 10 | 14 |  |  | 227
Pear2011 | Pear | 2011 | 9 | 24 | 47 | 45 | 41 | 78 | 71 | 64 | 25 | 17 | 5 | 56 | 482
Pear2012 | Pear | 2012 | 50 | 7 | 37 | 66 | 66 | 41 | 85 | 42 | 16 | 27 | 33 | 50 | 520
Pear2013 | Pear | 2013 | 32 | 16 | 35 | 55 | 81 | 58 | 71 | 84 | 20 | 18 | 19 | 131 | 620
Pear2014 | Pear | 2014 | 32 | 7 | 45 | 78 | 48 | 64 | 74 | 44 | 36 | 36 | 12 | 69 | 545
Pear2015 | Pear | 2015 | 18 | 44 | 51 | 39 | 61 | 41 | 35 | 32 | 24 | 20 | 14 | 94 | 473
Pear2016 | Pear | 2016 | 9 | 13 | 68 | 52 | 52 | 92 | 53 | 48 | 50 | 28 | 23 | 75 | 563
Pear2017 | Pear | 2017 | 28 | 28 | 54 | 45 | 51 | 57 | 71 | 53 | 33 | 14 |  |  | 434