Spreadsheet: 139742d1328430908-sumifs-function-based-on-date-range-and-sales-value-sales-data
Sheet: Sheet1

Date | Cash Sale | [NAME] | Credit Sale Collection | Total Cash Sale for the period of 01.11.2011 to 12.11.2011 | Total Cash Sale the period of 13.11.2011 to 19.11.2012
2011-11-01 00:00:00 | 67777.736 | 21602.2 | 872.465 | ???? | ????
2011-11-02 00:00:00 | 73794.656 | 24298.67 | 1859.655
2011-11-03 00:00:00 | 107874.198 | 39601.38 | 743.15
2011-11-04 00:00:00 | 104378.004 | 38247.89 | 867.945
2011-11-05 00:00:00 | 94406.361 | 31794.01 | 53.64
2011-11-06 00:00:00 | 22974.315 | 5698.94 | 8.465
2011-11-07 00:00:00 | 44364.067 | 11839.14 | 459.22
2011-11-08 00:00:00 | 37953.31 | 14572.75 | 60.37
2011-11-09 00:00:00 | 48565.08 | 23398.28 | 38.405
2011-11-10 00:00:00 | 60789.696 | 26366.07 | 174.95
2011-11-11 00:00:00 | 64783.712 | 30542.53 | 273.58
2011-11-12 00:00:00 | 52232.067 | 22345.6 | 2043.155
2011-11-13 00:00:00 | 45538.106 | 17713.06 | 1713.24
2011-11-14 00:00:00 | 45036.205 | 17223.65 | 782.92
2011-11-15 00:00:00 | 41751.075 | 14197.45 | 774.755
2011-11-16 00:00:00 | 49290.885 | 18751.65 | 981.65
2011-11-17 00:00:00 | 64141.35 | 28239.895 | 230.295
2011-11-18 00:00:00 | 63722.531 | 27460.905 | 83.635
2011-11-19 00:00:00 | 46672.565 | 17112.185 | 3344.485
2011-11-20 00:00:00 | 41116.625 | 14645.8 | 297.32
2011-11-21 00:00:00 | 41448.195 | 15785.475 | 741.56
2011-11-22 00:00:00 | 47617.235 | 19232.405 | 1227.96
2011-11-23 00:00:00 | 68855.114 | 26910.955 | 956.88
2011-11-24 00:00:00 | 108984.905 | 47204 | 83.69
2011-11-25 00:00:00 | 82414.837 | 41412.19 | 34.1
2011-11-26 00:00:00 | 82573.185 | 40380.32 | 104.23
2011-11-27 00:00:00 | 83260.81 | 42427.792 | 2933.875
2011-11-28 00:00:00 | 84899.155 | 47453.825 | 394.69
2011-11-29 00:00:00 | 63640.8 | 27445.51 | 4360.48
2011-11-30 00:00:00 | 65277.335 | 25750.85 | 5899.93
2011-12-01 00:00:00 | 83848.449 | 35708.206 | 1342.11
2011-12-02 00:00:00 | 80738.26 | 34189.645 | 156.76
2011-12-03 00:00:00 | 54914.279 | 22834.623 | 1430.85
2011-12-04 00:00:00 | 54199.085 | 20906.435 | 353.615
2011-12-05 00:00:00 | 55225.506 | 19540.76 | 5026.635
2011-12-06 00:00:00 | 50773.794 | 18992.425 | 312.25
2011-12-07 00:00:00 | 55042.635 | 20822.099 | 336.21
2011-12-08 00:00:00 | 75563.939 | 33197.605 | 862.015
2011-12-09 00:00:00 | 67630.57 | 33097.59 | 298.33
2011-12-10 00:00:00 | 49662.005 | 20168.598 | 555.775
2011-12-11 00:00:00 | 46736.24 | 14278.875 | 801.39
2011-12-12 00:00:00 | 43345.04 | 15937.175 | 547.295
2011-12-13 00:00:00 | 44498.33 | 16970.46 | 267.635
2011-12-14 00:00:00 | 51794.905 | 18620.38 | 1575.13
2011-12-15 00:00:00 | 64772.845 | 29042.205 | 46.815
2011-12-16 00:00:00 | 66099.305 | 30940.633 | 349.75
2011-12-17 00:00:00 | 47552.515 | 21909.795 | 335.895
2011-12-18 00:00:00 | 45716.489 | 17623.614 | 2363.296
2011-12-19 00:00:00 | 41960.419 | 19343.435 | 1112.705
2011-12-20 00:00:00 | 47761.89 | 19146.245 | 2104.049
2011-12-21 00:00:00 | 60634.979 | 23567.84 | 709.375
2011-12-22 00:00:00 | 94936.027 | 45921.491 | 1328.105
2011-12-23 00:00:00 | 96967.315 | 47489.53 | 474.61
2011-12-24 00:00:00 | 77689.264 | 33787.12 | 772.37
2011-12-25 00:00:00 | 75542.33 | 31704.02 | 1240.78
2011-12-26 00:00:00 | 77792.59 | 28871.765 | 490.335
2011-12-27 00:00:00 | 70147.456 | 26536.2 | 443.969
2011-12-28 00:00:00 | 65628.44 | 28435.43 | 386.624
2011-12-29 00:00:00 | 91147.343 | 39709.778 | 80.398
2011-12-30 00:00:00 | 84234.709 | 37633.586 | 169.094
2011-12-31 00:00:00 | 59997.325 | 29593.615 | 1169.754
2012-01-01 00:00:00 | 55844.75 | 20652.36 | 2226.46
2012-01-02 00:00:00 | 52826.75 | 21585.19 | 2321.63
2012-01-03 00:00:00 | 60310.709 | 19737.29 | 2108.385
2012-01-04 00:00:00 | 64718.51 | 24527.14 | 493.965
2012-01-05 00:00:00 | 76574.735 | 29932.76 | 279.01
2012-01-06 00:00:00 | 72082.798 | 30630.035 | 26.732
2012-01-07 00:00:00 | 53936.784 | 22943.485 | 1290.215
2012-01-08 00:00:00 | 50385.91 | 16562.58 | 1022.41
2012-01-09 00:00:00 | 49200.57 | 17888.52 | 1201.4
2012-01-10 00:00:00 | 52824.957 | 18941.483 | 380.795
2012-01-11 00:00:00 | 48803.026 | 18394.457 | 273.13
2012-01-12 00:00:00 | 67448.158 | 27528.795 | 555.515
2012-01-13 00:00:00 | 60122.267 | 25907.128 | 156.965
2012-01-14 00:00:00 | 47119.034 | 18958.375 | 654.254
2012-01-15 00:00:00 | 46098.27 | 16845.825 | 1865.35
2012-01-16 00:00:00 | 45489.709 | 20541.12 | 609.825
2012-01-17 00:00:00 | 45030.5 | 17123.525 | 3676.14
2012-01-18 00:00:00 | 46699.023 | 21086.81 | 1205.805
2012-01-19 00:00:00 | 64559.904 | 25517.62 | 2773.81
2012-01-20 00:00:00 | 60065.344 | 28920.6 | 130.755
2012-01-21 00:00:00 | 50430.95 | 18494.99 | 2413.13
2012-01-22 00:00:00 | 49388.525 | 18212.705 | 1122.765
2012-01-23 00:00:00 | 59163.44 | 25833.415 | 1791.26
2012-01-24 00:00:00 | 91058.989 | 34060.08 | 3452.45
2012-01-25 00:00:00 | 109727.205 | 36256.969 | 1481.86
2012-01-26 00:00:00 | 117537.769 | 51934.228 | 253.995
2012-01-27 00:00:00 | 109742.754 | 47470.876 | 33.97
2012-01-28 00:00:00 | 86677.429 | 37595.775 | 5451.42
2012-01-29 00:00:00 | 72383.83 | 32870.265 | 919.805
2012-01-30 00:00:00 | 71844.863 | 29329.18 | 407.515
2012-01-31 00:00:00 | 68045.245 | 26641.004 | 178.615
2012-02-01 00:00:00
2012-02-02 00:00:00
2012-02-03 00:00:00
2012-02-04 00:00:00
2012-02-05 00:00:00
2012-02-06 00:00:00
2012-02-07 00:00:00
2012-02-08 00:00:00
2012-02-09 00:00:00
2012-02-10 00:00:00
2012-02-11 00:00:00
2012-02-12 00:00:00
2012-02-13 00:00:00
2012-02-14 00:00:00
2012-02-15 00:00:00
2012-02-16 00:00:00
2012-02-17 00:00:00
2012-02-18 00:00:00
2012-02-19 00:00:00
2012-02-20 00:00:00
2012-02-21 00:00:00
2012-02-22 00:00:00
2012-02-23 00:00:00
2012-02-24 00:00:00
2012-02-25 00:00:00
2012-02-26 00:00:00
2012-02-27 00:00:00
2012-02-28 00:00:00
2012-02-29 00:00:00
2012-03-01 00:00:00
2012-03-02 00:00:00
2012-03-03 00:00:00
2012-03-04 00:00:00
2012-03-05 00:00:00
2012-03-06 00:00:00
2012-03-07 00:00:00
2012-03-08 00:00:00
2012-03-09 00:00:00
2012-03-10 00:00:00
2012-03-11 00:00:00
2012-03-12 00:00:00
2012-03-13 00:00:00
2012-03-14 00:00:00
2012-03-15 00:00:00
2012-03-16 00:00:00
2012-03-17 00:00:00
2012-03-18 00:00:00
2012-03-19 00:00:00
2012-03-20 00:00:00
2012-03-21 00:00:00
2012-03-22 00:00:00
2012-03-23 00:00:00
2012-03-24 00:00:00
2012-03-25 00:00:00
2012-03-26 00:00:00
2012-03-27 00:00:00
2012-03-28 00:00:00
2012-03-29 00:00:00
2012-03-30 00:00:00
2012-03-31 00:00:00