Spreadsheet: 269448d1381163997-best-way-to-sort-data-with-multiple-conditions-sales-tracker
Sheet: Last Year Sales

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | TOTAL
 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00 | 2012-10-07 00:00:00 | 2012-10-08 00:00:00 | 2012-10-09 00:00:00 | 2012-10-10 00:00:00 | 2012-10-11 00:00:00 | 2012-10-12 00:00:00 | 2012-10-13 00:00:00 | 2012-10-14 00:00:00 | 2012-10-15 00:00:00 | 2012-10-16 00:00:00 | 2012-10-17 00:00:00 | 2012-10-18 00:00:00 | 2012-10-19 00:00:00 | 2012-10-20 00:00:00 | 2012-10-21 00:00:00 | 2012-10-22 00:00:00 | 2012-10-23 00:00:00 | 2012-10-24 00:00:00 | 2012-10-25 00:00:00 | 2012-10-26 00:00:00 | 2012-10-27 00:00:00 | 2012-10-28 00:00:00 | 2012-10-29 00:00:00 | 2012-10-30 00:00:00
5:00-5:30AM
5:30-6:00AM
6:00-6:30 AM
6:30-7:00AM
7:00-7:30 AM
7:30-8:00AM
8:00-8:30 AM
8:30-9:00AM
9:00-9:30 AM
9:30-10:00AM
10:00-10:30AM
10:30-11:00AM
11:00-11:30PM
11:30-12:00PM
12:00-12:30PM
12:30-1:00PM
1:00-1:30PM
1:30-2:00PM
2:00-2:30PM
2:30-3:00PM
3:00-3:30PM
3:30-4:00PM
4:00-4:30PM
4:30-5:00PM
5:00-5:30PM
5:30-6:00PM
6:00-6:30PM
6:30-7:00PM
7:00-7:30PM
7:30-8:00PM
8:00-8:30PM
8:30-9:00PM
9:00-9:30PM
9:30-10:00PM
10:00-10:30PM
10:30-11:00PM
11:00- 11:30PM
11:30- 12AM
12-12:30AM
12:30- 1AM
1-1:30AM
1:30- 2AM
2-3AM
TOTAL SALES | 4183.52 | 3444.63 | 3227.08 | 3979.56 | 4356.46 | 3894.9 | 4382.13 | 4085.66 | 3458.9 | 3335.62 | 3370.98 | 3657.09 | 4152.65 | 5237.86 | 4534.27 | 3229.92 | 4073.91 | 3632.96 | 4247.16 | 4083.1 | 4857.32 | 4144.35 | 3614.42 | 3959.49 | 4006.28 | 4136.93 | 4563.57 | 4860.98 | 4355.88 | 3480.92 | 120548.5
 | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1
 | 2012-09-01 00:00:00 | 2012-09-02 00:00:00 | 2012-09-03 00:00:00 | 2012-09-04 00:00:00 | 2012-09-05 00:00:00 | 2012-09-06 00:00:00 | 2012-09-07 00:00:00 | 2012-09-08 00:00:00 | 2012-09-09 00:00:00 | 2012-09-10 00:00:00 | 2012-09-11 00:00:00 | 2012-09-12 00:00:00 | 2012-09-13 00:00:00 | 2012-09-14 00:00:00 | 2012-09-15 00:00:00 | 2012-09-16 00:00:00 | 2012-09-17 00:00:00 | 2012-09-18 00:00:00 | 2012-09-19 00:00:00 | 2012-09-20 00:00:00 | 2012-09-21 00:00:00 | 2012-09-22 00:00:00 | 2012-09-23 00:00:00 | 2012-09-24 00:00:00 | 2012-09-25 00:00:00 | 2012-09-26 00:00:00 | 2012-09-27 00:00:00 | 2012-09-28 00:00:00 | 2012-09-29 00:00:00 | 2012-09-30 00:00:00
open-11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11:00-2:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2:00-5:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5:00-8:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8:00-close | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0