Track daily/weekly/monthly/YTD

[erw627]

Hi! I am attempting to take these monthly tables and then summarizing them into tables to display weekly, monthly, and year to date totals per timeframe (ex. 12am-6am, 6am-7am, etc.). Is there a way to make tables that will automatically pull from the data in each month?

I watch Youtube videos to try to figure these things out, but I've got too many pieces I'm trying to pull together with this one. Any help is appreciated!

Schedule Notifications Pivot Table.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Date	12am-6am	6am-7am	7am-8am	8am-9am	9am-10am	10am-11am	11am-12pm	12pm-1pm	1pm-2pm	2pm-3pm	3pm-4pm	4pm-5pm	5pm-6pm	6pm-7pm	7pm-8pm	8pm-11:59pm	Total
2	1/1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
3	1/2	0	0	0	0	0	1	2	0	0	0	0	0	0	0	0	0	3
4	1/3	0	0	1	1	0	1	0	0	0	0	0	0	0	0	0	0	3
5	1/4	0	0	1	1	1	1	0	0	0	3	0	0	0	0	0	0	7
6	1/5	0	0	0	1	0	0	0	2	0	0	0	0	0	0	0	0	3
7	1/6	0	0	1	0	0	0	0	0	1	0	1	0	0	0	0	0	3
8	1/7	0	0	1	0	1	0	0	0	0	0	0	0	0	0	2	0	4
9	1/8	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	1
10	1/9	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
11	1/10	0	0	0	2	0	0	0	1	0	1	0	0	0	0	0	0	4
12	1/11	0	0	1	0	0	0	0	0	0	0	0	0	0	2	0	0	3
13	1/12	0	0	0	0	0	0	0	1	3	0	0	0	0	0	0	0	4
14	1/13	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0	2
15	1/14	0	0	1	0	0	1	0	1	0	0	0	1	0	1	1	1	7
16	1/15	0	0	0	0	0	0	3	0	1	0	0	0	0	0	0	0	4
17	1/16	0	0	0	0	0	2	0	0	0	0	0	0	0	0	0	0	2
18	1/17	0	0	0	0	0	0	0	0	0	0	0	5	0	0	0	0	5
19	1/18	0	0	1	3	1	0	0	0	0	0	0	0	0	1	0	0	6
20	1/19	0	0	1	1	0	0	0	0	1	0	1	0	0	0	0	0	4
21	1/20	0	0	0	0	1	1	1	0	0	0	0	0	0	1	0	0	4
22	1/21	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1
23	1/22	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
24	1/23	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
25	1/24	0	0	0	0	0	0	0	0	1	1	0	0	0	0	1	0	3
26	1/25	0	0	1	0	0	0	0	1	0	1	1	0	0	6	0	0	10
27	1/26	0	0	0	1	0	0	0	1	0	0	1	1	0	0	0	0	4
28	1/27	0	0	0	0	1	0	0	0	0	0	0	0	0	0	1	0	2
29	1/28	0	0	0	1	2	0	0	0	0	0	0	0	0	0	0	0	3
30	1/29	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	1
31	1/30	0	0	0	0	0	0	0	0	0	2	0	0	0	0	0	0	2
32	1/31	0	0	0	0	1	1	0	0	0	1	0	1	0	0	2	0	6
33	Total	0	0	10	11	8	10	6	7	8	9	4	8	8	9	4	8	101
January

Cell Formulas
Range	Formula
R2:R32	R2	=SUM(B2:Q2)
B33	B33	=SUBTOTAL(109,[12am-6am])
C33	C33	=SUBTOTAL(109,[6am-7am])
D33	D33	=SUBTOTAL(109,[7am-8am])
E33	E33	=SUBTOTAL(109,[8am-9am])
F33	F33	=SUBTOTAL(109,[9am-10am])
G33	G33	=SUBTOTAL(109,[10am-11am])
H33	H33	=SUBTOTAL(109,[11am-12pm])
I33	I33	=SUBTOTAL(109,[12pm-1pm])
J33,N33	J33	=SUBTOTAL(109,[1pm-2pm])
K33,O33	K33	=SUBTOTAL(109,[2pm-3pm])
L33,P33	L33	=SUBTOTAL(109,[3pm-4pm])
M33,Q33	M33	=SUBTOTAL(109,[4pm-5pm])
R33	R33	=SUBTOTAL(109,[Total])