Spreadsheet: 126499d1319724321-excel-average-average-if-array-formula
Sheet: Sheet1

Date | Data |  |  | Month | Average
2011-06-01 00:00:00 | 324 |  |  | 2011-06-01 00:00:00 | 99.14583333333333
2011-06-02 00:00:00 | 412 |  |  | 2011-07-01 00:00:00 | 114.1597222222222
2011-06-03 00:00:00 | 795 |  |  | 2011-08-01 00:00:00 | 115.0277777777778
2011-06-04 00:00:00 | 794 |  |  | 2011-09-01 00:00:00 | 112.0625
2011-06-05 00:00:00 | 169 |  |  | 2011-10-01 00:00:00 | 73.50694444444444
2011-06-06 00:00:00 | 140
2011-06-07 00:00:00 | 261
2011-06-08 00:00:00 | 162
2011-06-09 00:00:00 | 294
2011-06-10 00:00:00 | 859
2011-06-11 00:00:00 | 597
2011-06-12 00:00:00 | 388
2011-06-13 00:00:00 | 821
2011-06-14 00:00:00 | 771
2011-06-15 00:00:00 | 6
2011-06-16 00:00:00 | 621
2011-06-17 00:00:00 | 688
2011-06-18 00:00:00 | 956
2011-06-19 00:00:00 | 21
2011-06-20 00:00:00 | 367
2011-06-21 00:00:00 | 192
2011-06-22 00:00:00 | 542
2011-06-23 00:00:00 | 773
2011-06-24 00:00:00 | 704
2011-06-25 00:00:00 | 534
2011-06-26 00:00:00 | 50
2011-06-27 00:00:00 | 480
2011-06-28 00:00:00 | 425
2011-06-29 00:00:00 | 167
2011-06-30 00:00:00 | 964
2011-07-01 00:00:00 | 439
2011-07-02 00:00:00 | 373
2011-07-03 00:00:00 | 293
2011-07-04 00:00:00 | 501
2011-07-05 00:00:00 | 857
2011-07-06 00:00:00 | 601
2011-07-07 00:00:00 | 345
2011-07-08 00:00:00 | 621
2011-07-09 00:00:00 | 708
2011-07-10 00:00:00 | 239
2011-07-11 00:00:00 | 167
2011-07-12 00:00:00 | 105
2011-07-13 00:00:00 | 552
2011-07-14 00:00:00 | 639
2011-07-15 00:00:00 | 461
2011-07-16 00:00:00 | 856
2011-07-17 00:00:00 | 612
2011-07-18 00:00:00 | 722
2011-07-19 00:00:00 | 815
2011-07-20 00:00:00 | 369
2011-07-21 00:00:00 | 622
2011-07-22 00:00:00 | 873
2011-07-23 00:00:00 | 666
2011-07-24 00:00:00 | 578
2011-07-25 00:00:00 | 382
2011-07-26 00:00:00 | 950
2011-07-27 00:00:00 | 159
2011-07-28 00:00:00 | 327
2011-07-29 00:00:00 | 739
2011-07-30 00:00:00 | 359
2011-07-31 00:00:00 | 509
2011-08-01 00:00:00 | 640
2011-08-02 00:00:00 | 894
2011-08-03 00:00:00 | 905
2011-08-04 00:00:00 | 115
2011-08-05 00:00:00 | 589
2011-08-06 00:00:00 | 76
2011-08-07 00:00:00 | 500
2011-08-08 00:00:00 | 675
2011-08-09 00:00:00 | 110
2011-08-10 00:00:00 | 851
2011-08-11 00:00:00 | 614
2011-08-12 00:00:00 | 204
2011-08-13 00:00:00 | 989
2011-08-14 00:00:00 | 943
2011-08-15 00:00:00 | 508
2011-08-16 00:00:00 | 143
2011-08-17 00:00:00 | 752
2011-08-18 00:00:00 | 202
2011-08-19 00:00:00 | 807
2011-08-20 00:00:00 | 283
2011-08-21 00:00:00 | 442
2011-08-22 00:00:00 | 952
2011-08-23 00:00:00 | 680
2011-08-24 00:00:00 | 451
2011-08-25 00:00:00 | 538
2011-08-26 00:00:00 | 190
2011-08-27 00:00:00 | 780
2011-08-28 00:00:00 | 87
2011-08-29 00:00:00 | 797
2011-08-30 00:00:00 | 473
2011-08-31 00:00:00 | 374
2011-09-01 00:00:00 | 548
2011-09-02 00:00:00 | 579
2011-09-03 00:00:00 | 913
2011-09-04 00:00:00 | 112
2011-09-05 00:00:00 | 809
2011-09-06 00:00:00 | 342
2011-09-07 00:00:00 | 867
2011-09-08 00:00:00 | 2
2011-09-09 00:00:00 | 488
2011-09-10 00:00:00 | 379
2011-09-11 00:00:00 | 991
2011-09-12 00:00:00 | 310
2011-09-13 00:00:00 | 162
2011-09-14 00:00:00 | 758
2011-09-15 00:00:00 | 832
2011-09-16 00:00:00 | 616
2011-09-17 00:00:00 | 420
2011-09-18 00:00:00 | 439
2011-09-19 00:00:00 | 150
2011-09-20 00:00:00 | 264
2011-09-21 00:00:00 | 824
2011-09-22 00:00:00 | 981
2011-09-23 00:00:00 | 770
2011-09-24 00:00:00 | 824
2011-09-25 00:00:00 | 855
2011-09-26 00:00:00 | 832
2011-09-27 00:00:00 | 110
2011-09-28 00:00:00 | 387
2011-09-29 00:00:00 | 369
2011-09-30 00:00:00 | 204
2011-10-01 00:00:00 | 890
2011-10-02 00:00:00 | 976
2011-10-03 00:00:00 | 674
2011-10-04 00:00:00 | 212
2011-10-05 00:00:00 | 767
2011-10-06 00:00:00 | 238
2011-10-07 00:00:00 | 117
2011-10-08 00:00:00 | 19
2011-10-09 00:00:00 | 563
2011-10-10 00:00:00 | 198
2011-10-11 00:00:00 | 179
2011-10-12 00:00:00 | 191
2011-10-13 00:00:00 | 276
2011-10-14 00:00:00 | 745
2011-10-15 00:00:00 | 894
2011-10-16 00:00:00 | 703
2011-10-17 00:00:00 | 300
2011-10-18 00:00:00 | 611
2011-10-19 00:00:00 | 492
2011-10-20 00:00:00 | 302
2011-10-21 00:00:00 | 265
2011-10-22 00:00:00 | 973