Spreadsheet: 709266d1608224945-how-to-automatically-sum-day-wise-data-from-database-test-1-
Sheet: Sheet2

Place | 01-Sep | 02-Sep | 03-Sep | 04-Sep | 05-Sep | 06-Sep | 07-Sep | 08-Sep | 09-Sep | 10-Sep | 11-Sep | 12-Sep | 13-Sep | 14-Sep | 15-Sep | 16-Sep | 17-Sep | 18-Sep | 19-Sep | 20-Sep | 21-Sep | 22-Sep | 23-Sep | 24-Sep | 25-Sep | 26-Sep | 27-Sep | 28-Sep | 29-Sep | 30-Sep | Grand Total
A | 296.9999999999998 | 260.0000000000003 | 264.0000000000003 | 103 | 201 | 251.0000000000003 | 239.0000000000004 | 251.0000000000003 | 290.0000000000001 | 310 | 102 | 251.0000000000002 | 295 | 285 | 278.9999999999999 | 246.0000000000001 | 278.0000000000001 | 56.00000000000001 | 175 | 259.0000000000003 | 274.0000000000001 | 176 | 244.0000000000001 | 252 | 61.00000000000001 | 219.0000000000001 | 237.0000000000001 | 281.0000000000001 | 237.0000000000001 | 525.9999999999995
B | 308.9999999999999 | 371.9999999999998 | 349.0000000000001 | 124 | 304 | 291.9999999999996 | 361.9999999999996 | 344.9999999999998 | 401.9999999999998 | 480.9999999999998 | 267 | 378.9999999999998 | 359.9999999999998 | 339.9999999999995 | 404.9999999999996 | 330.9999999999997 | 350.9999999999999 | 128.9999999999999 | 320.0000000000001 | 327.9999999999998 | 283.9999999999998 | 264.0000000000001 | 360.9999999999998 | 480.9999999999995 | 174.0000000000001 | 348.9999999999999 | 469.9999999999998 | 312 | 405.9999999999995 | 772.0000000000006
C | 350.999999999999 | 337.9999999999987 | 381.9999999999992 | 90.99999999999997 | 283.9999999999991 | 370.9999999999991 | 518.9999999999994 | 354.9999999999994 | 325.9999999999998 | 357.9999999999998 | 90.99999999999997 | 284.9999999999995 | 538.0000000000005 | 461.9999999999992 | 371.9999999999996 | 354.9999999999995 | 330.9999999999993 | 80 | 346.9999999999994 | 299.9999999999998 | 224.0000000000003 | 275.9999999999997 | 223.0000000000001 | 264.0000000000003 | 69 | 215.0000000000007 | 309.9999999999995 | 297.9999999999993 | 265.0000000000002 | 558.0000000000009
D | 156.0000000000001 | 253.0000000000007 | 279.0000000000001 | 57.00000000000002 | 239.0000000000002 | 266.0000000000002 | 222.0000000000001 | 255.0000000000002 | 298.0000000000001 | 264.0000000000001 | 82 | 280.9999999999999 | 300 | 271.9999999999999 | 291.9999999999999 | 287.9999999999998 | 242 | 47 | 214.0000000000001 | 265.0000000000001 | 269.0000000000001 | 204 | 238.0000000000001 | 249.0000000000001 | 48 | 200.0000000000001 | 263.0000000000001 | 279.0000000000001 | 267.0000000000001 | 509.9999999999998
E | 295.0000000000003 | 263.0000000000002 | 313.9999999999999 | 59.00000000000001 | 219.0000000000002 | 318.9999999999999 | 275.0000000000003 | 260.0000000000003 | 277.0000000000001 | 339.9999999999997 | 78 | 282.0000000000002 | 328 | 319.9999999999996 | 324.0000000000001 | 245.0000000000003 | 286.0000000000001 | 72.00000000000001 | 187 | 385.9999999999997 | 315.9999999999998 | 267.0000000000003 | 297.0000000000003 | 358 | 98 | 278.0000000000002 | 395.9999999999998 | 355.9999999999995 | 384.0000000000002 | 1008.000000000004
F | 133 | 156 | 147 | 57.00000000000001 |  | 185.0000000000001 | 152.0000000000001 | 151.0000000000001 | 183 | 169.0000000000001 | 39 | 146 | 215.0000000000001 | 301.0000000000001 | 236 | 205.0000000000001 | 174 | 45.00000000000001 | 123 | 161.0000000000001 | 207 | 145.0000000000001 | 156.0000000000001 | 157.0000000000001 | 34 | 151 | 213 | 173.0000000000001 | 173 | 294
G | 198 | 284.9999999999999 | 249.0000000000001 | 190.0000000000001 | 186.0000000000001 | 309.9999999999998 | 263.0000000000002 | 294.9999999999998 | 328.9999999999998 | 228 | 203 | 293.9999999999999 | 372.9999999999998 | 426.9999999999998 | 251.0000000000001 | 267.0000000000001 | 256.0000000000002 | 214.0000000000001 | 166 | 222.0000000000002 | 240.0000000000001 | 238.0000000000001 | 197.0000000000001 | 216.9999999999999 | 192 | 235 | 296 | 285.9999999999999 | 264.0000000000001 | 441.9999999999995
H | 317.9999999999999 | 357.9999999999998 | 324.9999999999999 | 131 | 326.9999999999999 | 334.9999999999997 | 368.9999999999997 | 311.9999999999999 | 392.9999999999999 | 323 | 162 | 341 | 401.9999999999999 | 400.9999999999997 | 424.9999999999997 | 305 | 328.0000000000001 | 116 | 285.9999999999999 | 301 | 333.9999999999998 | 335.9999999999997 | 353.9999999999997 | 320.9999999999998 | 122 | 337.9999999999998 | 325.9999999999998 | 356.9999999999999 | 274 | 503.9999999999997
I | 197.0000000000002 | 236.0000000000003 | 259.0000000000003 | 42.00000000000001 | 186.0000000000001 | 280.9999999999998 | 284.0000000000002 | 290.9999999999998 | 301.9999999999995 | 258.0000000000002 | 37 | 228.0000000000003 | 321.9999999999995 | 243.0000000000004 | 210.9999999999999 | 204.0000000000002 | 219.0000000000001 | 35 | 209.0000000000001 | 248.0000000000002 | 192.0000000000002 | 222 | 207 | 267.0000000000001 | 27 | 242.0000000000001 | 301.9999999999998 | 208 | 262.0000000000003 | 650
J | 280.9999999999998 | 291.9999999999996 | 307.9999999999997 | 45 | 258.0000000000001 | 332.9999999999997 | 281.9999999999998 | 309.9999999999998 | 345.9999999999995 | 360.9999999999994 | 76 | 326.9999999999997 | 338.9999999999994 | 317.9999999999994 | 303.9999999999994 | 303.9999999999995 | 304.9999999999993 | 58.00000000000001 | 220.0000000000001 | 275.9999999999998 | 237.0000000000003 | 267.0000000000001 | 245.0000000000002 | 284.9999999999995 | 56.00000000000003 | 252.0000000000001 | 305.9999999999995 | 286.9999999999998 | 301.9999999999996 | 529.9999999999997
K | 313.0000000000001 | 380.9999999999997 | 386 | 136.9999999999999 | 371.9999999999999 | 418.9999999999997 | 394.9999999999998 | 393.9999999999999 | 421.0000000000001 | 509.999999999999 | 219.0000000000001 | 463.9999999999995 | 478.9999999999999 | 513.9999999999997 | 463.9999999999997 | 460.9999999999996 | 334.0000000000002 | 214 | 400.9999999999999 | 450.9999999999997 | 440.9999999999999 | 442.9999999999997 | 570.9999999999992 | 469.9999999999998 | 214 | 389 | 456.9999999999998 | 493.9999999999997 | 449.9999999999995 | 900.0000000000015
L | 350.9999999999998 | 372.9999999999998 | 511.9999999999988 | 210 | 339.0000000000005 | 438.9999999999999 | 444.9999999999995 | 403.9999999999996 | 355.9999999999996 | 460.9999999999993 | 225.0000000000001 | 364.0000000000001 | 415.9999999999996 | 400.9999999999995 | 373.9999999999998 | 375.9999999999994 | 391.9999999999997 | 164 | 377.9999999999999 | 379.9999999999997 | 336.9999999999999 | 389.9999999999999 | 428.0000000000001 | 453.9999999999996 | 215.0000000000001 | 400.9999999999999 | 456.9999999999998 | 451 | 463.9999999999997 | 922.0000000000017
M | 157.0000000000001 | 252.9999999999999 | 226.0000000000002 | 56.00000000000001 | 197 | 211.0000000000001 | 145 | 226 | 223.0000000000001 | 220 | 48 | 211 | 231.0000000000001 | 203.0000000000002 | 201.0000000000001 | 195.0000000000001 | 242.0000000000002 | 27 | 169.9999999999999 | 219.0000000000002 | 218 | 202.0000000000001 | 220 | 255.0000000000003 | 22 | 174 | 219.9999999999999 | 195.0000000000001 | 221 | 483.9999999999999
N | 185 | 305.9999999999998 | 409.9999999999992 | 77.00000000000001 | 302.0000000000002 | 348.9999999999998 | 325.0000000000004 | 339.9999999999993 | 393.999999999999 | 523.9999999999985 | 80.00000000000001 | 384.9999999999998 | 445.9999999999994 | 398.9999999999999 | 362.9999999999997 | 358 | 335.0000000000001 | 79 | 233.0000000000001 | 270.0000000000001 | 240.0000000000001 | 253.0000000000003 | 340.9999999999997 | 281.0000000000003 | 73 | 267.0000000000003 | 352.9999999999996 | 294.9999999999997 | 305.0000000000002 | 650.0000000000003
O | 376.9999999999999 | 380.9999999999993 | 370.9999999999997 | 59.99999999999999 | 299.9999999999999 | 374.9999999999999 | 302.0000000000002 | 387.9999999999995 | 355.9999999999998 | 328.0000000000001 | 85 | 294 | 427.9999999999995 | 479.9999999999993 | 531.9999999999998 | 544.0000000000001 | 338.9999999999999 | 87.99999999999999 | 406.9999999999993 | 344.9999999999999 | 334.9999999999995 | 254 | 303.9999999999999 | 282 | 51.00000000000001 | 269.0000000000001 | 133.9999999999999 | 265.0000000000001 | 255.0000000000001 | 483.9999999999995
P | 248.0000000000002 | 316.9999999999999 | 326 | 42.00000000000001 | 298 | 354.9999999999999 | 280.0000000000001 | 368.9999999999997 | 333 | 360.9999999999997 | 56.00000000000001 | 282.0000000000001 | 347.9999999999999 | 341.9999999999997 | 327.9999999999999 | 305.0000000000001 | 290.0000000000001 | 45 | 231.0000000000001 | 245.0000000000001 | 250.0000000000001 | 276.0000000000001 | 271.0000000000001 | 231.0000000000001 | 50 | 233 | 265.0000000000001 | 274.0000000000001 | 327.9999999999999 | 618.0000000000006
Q | 183.9999999999999 | 187.0000000000001 | 209 | 45 | 117 | 206.0000000000001 | 229 | 196 | 195 | 175 | 36 | 163 | 180.9999999999999 | 210 | 184.0000000000001 | 183 | 192 | 34 | 125 | 231.0000000000001 | 206.0000000000001 | 181 | 205 | 227 | 55.00000000000001 | 161 | 228.0000000000001 | 237 | 235.9999999999999 | 493.9999999999997
Grand Total | 4349.999999999999 | 5010.999999999998 | 5315.999999999997 | 1526 | 4129 | 5296.999999999997 | 5088 | 5141.999999999998 | 5423.999999999997 | 5670.999999999995 | 1886 | 4976.999999999999 | 6000.999999999997 | 5917.999999999995 | 5544.999999999998 | 5171.999999999998 | 4893.999999999998 | 1503 | 4191.999999999998 | 4886.999999999999 | 4604 | 4394 | 4861.999999999998 | 5050.999999999999 | 1561 | 4373.000000000002 | 5232.999999999998 | 5047.999999999998 | 5093 | 10346.00000000001
Place | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
Grand Total