Spreadsheet: 271063d1381801266-sum-if-based-on-two-criteria-and-values-in-multiple-rows-and-columns-sum-issue
Sheet: Sheet1

Financial Week | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
Month | 2013-11-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2013-12-01 00:00:00 | 2013-12-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00 | 2014-01-01 00:00:00
[NAME] | 16214.14491428571 | 31077.32132727138 | 32605.8048 | 34049.70432 | 38961.86174208 | 31077.32132727138 | 32038.47559512514 | 31077.32132727138 | 48691.0771776
[NAME] | 412.5269387755101 | 825.0538775510203 | 825.0538775510203 | 866.3065714285713 | 1000.054717714286 | 825.0538775510203 | 850.571007784557 | 825.0538775510203 | 1238.818397142857
[NAME] | 1550.48967089369 | 4420.140646779881 | 2900.316354984936 | 3256.028308876749 | 3733.896385355 | 4420.140646779881 | 4556.846027608124 | 4420.140646779881 | 4656.120481693751
[NAME] 24 | 585.7567346938777 | 1171.513469387755 | 1171.513469387755 | 1230.089142857143 | 1416.221979428572 | 1171.513469387755 | 1207.745844729645 | 1171.513469387755 | 1759.027474285715
[NAME] | 24.24489795918365 | 48.48979591836729 | 48.48979591836729 | 50.91428571428566 | 67.2459428571428 | 48.48979591836729 | 49.9894803282137 | 48.48979591836729 | 72.80742857142849
[NAME] | 1102.040816326531 | 2204.081632653061 | 2204.081632653061 | 2314.285714285714 | 2656.542857142857 | 2204.081632653061 | 2272.249105827898 | 2204.081632653061 | 3309.428571428571
[NAME] | 185.1428571428571 | 370.2857142857143 | 370.2857142857143 | 388.8 | 453.7872 | 370.2857142857143 | 381.7378497790869 | 370.2857142857143 | 555.984
[NAME] | 181.3518367346939 | 362.7036734693878 | 362.7036734693878 | 380.8388571428571 | 444.6796525714285 | 362.7036734693878 | 373.9213128550389 | 362.7036734693878 | 544.5995657142856
[NAME] | 553.2685714285714 | 1106.537142857143 | 1106.537142857143 | 1161.864 | 1338.172416 | 1106.537142857143 | 1140.759941089838 | 1106.537142857143 | 1661.46552
Received [NAME] 6 | 16232.55769725037 | 31112.61273337063 | 32642.83195193088 | 34088.37116422579 | 39006.10683227431 | 31112.61273337063 | 32074.85848801096 | 31112.61273337063 | 48746.37076484288 |  |  | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00
Received Mod 8 | 412.9954043671836 | 825.9908087343672 | 825.9908087343672 | 867.2903491710856 | 1001.190379851722 | 825.9908087343672 | 851.5369162209971 | 825.9908087343672 | 1240.225199314652 |  | [NAME]
Received Mod 12 | 1552.250406963957 | 4425.160158498364 | 2903.609954237657 | 3259.725854624309 | 3738.13659809021 | 4425.160158498364 | 4562.020781957076 | 4425.160158498364 | 4661.407972112762 |  | [NAME]
Received Mod 24 | 586.421920041796 | 1172.843840083592 | 1172.843840083592 | 1231.486032087772 | 1417.830241108411 | 1172.843840083592 | 1209.11736091092 | 1172.843840083592 | 1761.025025885514 |  | [NAME]
Received Bulk | 24.72979591836732 | 49.45959183673464 | 49.45959183673464 | 51.93257142857138 | 68.59086171428565 | 49.45959183673464 | 50.98926993477798 | 49.45959183673464 | 74.26357714285706 |  | Wasted KG
[NAME] | 1124.081632653061 | 2248.163265306122 | 2248.163265306122 | 2360.571428571428 | 2709.673714285714 | 2248.163265306122 | 2317.694087944456 | 2248.163265306122 | 3375.617142857142
Received 6Pk | 188.8457142857143 | 377.6914285714286 | 377.6914285714286 | 396.576 | 462.862944 | 377.6914285714286 | 389.3726067746687 | 377.6914285714286 | 567.10368
Received 3Pk | 184.9788734693878 | 369.9577469387755 | 369.9577469387755 | 388.4556342857143 | 453.5732456228571 | 369.9577469387755 | 381.3997391121397 | 369.9577469387755 | 555.4915570285714
Received 1.5Pk | 564.3339428571428 | 1128.667885714286 | 1128.667885714286 | 1185.10128 | 1364.93586432 | 1128.667885714286 | 1163.575139911635 | 1128.667885714286 | 1694.6948304
[NAME] | 16214.14491428571 | 31077.32132727138 | 32605.8048 | 34049.70432 | 38961.86174208 | 31077.32132727138 | 32038.47559512514 | 31077.32132727138 | 48691.0771776
[NAME] | 412.5269387755101 | 825.0538775510203 | 825.0538775510203 | 866.3065714285713 | 1000.054717714286 | 825.0538775510203 | 850.571007784557 | 825.0538775510203 | 1238.818397142857
[NAME] 12 | 1550.48967089369 | 4420.140646779881 | 2900.316354984936 | 3256.028308876749 | 3733.896385355 | 4420.140646779881 | 4556.846027608124 | 4420.140646779881 | 4656.120481693751
[NAME] 24 | 585.7567346938777 | 1171.513469387755 | 1171.513469387755 | 1230.089142857143 | 1416.221979428572 | 1171.513469387755 | 1207.745844729645 | 1171.513469387755 | 1759.027474285715
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 181.44 | 362.88 | 362.88 | 381.024 | 444.7114560000001 | 362.88 | 374.1030927835051 | 362.88 | 544.86432
Ripened 3Pk | 177.7248 | 355.4496 | 355.4496 | 373.22208 | 435.7860595199999 | 355.4496 | 366.4428865979381 | 355.4496 | 533.7075743999999
Ripened 1.5Pk | 542.2031999999999 | 1084.4064 | 1084.4064 | 1138.62672 | 1311.40896768 | 1084.4064 | 1117.944742268041 | 1084.4064 | 1628.2362096
Wasted [NAME] 6 | 18.41278296466226 | 35.29140609925162 | 37.02715193088079 | 38.66684422579419 | 44.24509019430843 | 35.29140609925162 | 36.38289288582382 | 35.29140609925162 | 55.29358724288613
Wasted [NAME] 8 | 0.4684655916734641 | 0.9369311833469283 | 0.9369311833469283 | 0.9837777425143486 | 1.135662137436384 | 0.9369311833469283 | 0.9659084364401451 | 0.9369311833469283 | 1.406802171795334
Wasted [NAME] 12 | 1.76073607026683 | 5.019511718483045 | 3.293599252720924 | 3.697545747560525 | 4.240212735209298 | 5.019511718483045 | 5.174754348951865 | 5.019511718483045 | 5.287490419011192
Wasted [NAME] 24 | 0.6651853479183956 | 1.330370695836791 | 1.330370695836791 | 1.396889230628631 | 1.608261679839188 | 1.330370695836791 | 1.371516181274956 | 1.330370695836791 | 1.997551599798953
Wasted Bulk | 0.4848979591836731 | 0.9697959183673461 | 0.9697959183673461 | 1.018285714285717 | 1.344918857142858 | 0.9697959183673461 | 0.9997896065642777 | 0.9697959183673461 | 1.456148571428571
Wasted Bin | 22.0408163265306 | 44.08163265306121 | 44.08163265306121 | 46.28571428571422 | 53.13085714285717 | 44.08163265306121 | 45.44498211655809 | 44.08163265306121 | 66.18857142857132
Wasted 6Pk | 3.702857142857141 | 7.405714285714282 | 7.405714285714282 | 7.77600000000001 | 9.075743999999986 | 7.405714285714282 | 7.634756995581768 | 7.405714285714282 | 11.11968000000002
Wasted 3Pk | 3.627036734693888 | 7.254073469387777 | 7.254073469387777 | 7.616777142857131 | 8.893593051428581 | 7.254073469387777 | 7.478426257100807 | 7.254073469387777 | 10.89199131428575
Wasted 1.5Pk | 11.06537142857144 | 22.13074285714288 | 22.13074285714288 | 23.23728000000006 | 26.76344831999995 | 22.13074285714288 | 22.81519882179668 | 22.13074285714288 | 33.22931040000003