Manipulate hourly data into daily data

[hip2b2]

I have months and months of hourly energy data that I want to review as daily data.

HQ Hourly Dec 1 2022 - Jan 16 2023.csv
	A	B	C	D
1	Date and time	Lower kWh	Higher kWh	Average temperature (°C)
2	01/12/2022 0:00	6.02	0	1
3	01/12/2022 1:00	8.7	0	1
4	01/12/2022 2:00	6.9	0	0
5	01/12/2022 3:00	0.56	0	0
6	01/12/2022 4:00	4.53	0	0
7	01/12/2022 5:00	12.96	0	0
8	01/12/2022 6:00	3.6	0	0
9	01/12/2022 7:00	0.69	0	0
10	01/12/2022 8:00	0.59	0	-1
11	01/12/2022 9:00	0.97	0	0
12	01/12/2022 10:00	0.57	0	1
13	01/12/2022 11:00	0.63	0	1
14	01/12/2022 12:00	0.57	0	0
15	01/12/2022 13:00	0.58	0	1
16	01/12/2022 14:00	1.03	0	1
17	01/12/2022 15:00	0.64	0	1
18	01/12/2022 16:00	0.73	0	1
19	01/12/2022 17:00	1.33	0	1
20	01/12/2022 18:00	0.73	0	0
21	01/12/2022 19:00	0.7	0	0
22	01/12/2022 20:00	2.93	0	-1
23	01/12/2022 21:00	6.03	0	-1
24	01/12/2022 22:00	10.63	0	-1
25	01/12/2022 23:00	11.82	0	-2
HQ Hourly Dec 1 2022 - Jan 16 2

I would like to combine each single day's hourly data to a single daily value, with Column B values summed, Column C values summed, and Column D values averaged.

Any suggestions as to best approach?

 

[JamesCanale]

MrExcelPlayground15.xlsx
	A	B	C	D	E	F	G	H	I
1	Date and time	Lower kWh	Higher kWh	Average temperature (°C)		Date	Lower kWh	Higher kWh	Average temperature (°C)
2	12/01/2022 0:00	6.02	0	1		12/1/2022	84.44	0	0.125
3	12/01/2022 1:00	8.7	0	1		12/2/2022	30.52	0	0.25
4	12/01/2022 2:00	6.9	0	0		12/3/2022	28.67	0	0.333333
5	12/01/2022 3:00	0.56	0	0		12/4/2022	22.6	0	0.416667
6	12/01/2022 4:00	4.53	0	0		12/5/2022	31.43	0	0.166667
7	12/01/2022 5:00	12.96	0	0
8	12/01/2022 6:00	3.6	0	0
9	12/01/2022 7:00	0.69	0	0
10	12/01/2022 8:00	0.59	0	-1
11	12/01/2022 9:00	0.97	0	0
12	12/01/2022 10:00	0.57	0	1
13	12/01/2022 11:00	0.63	0	1
14	12/01/2022 12:00	0.57	0	0
15	12/01/2022 13:00	0.58	0	1
16	12/01/2022 14:00	1.03	0	1
17	12/01/2022 15:00	0.64	0	1
18	12/01/2022 16:00	0.73	0	1
19	12/01/2022 17:00	1.33	0	1
20	12/01/2022 18:00	0.73	0	0
21	12/01/2022 19:00	0.7	0	0
22	12/01/2022 20:00	2.93	0	-1
23	12/01/2022 21:00	6.03	0	-1
24	12/01/2022 22:00	10.63	0	-1
25	12/01/2022 23:00	11.82	0	-2
26	12/02/2022 0:00	3.6	0	0
27	12/02/2022 1:00	0.69	0	0
28	12/02/2022 2:00	0.59	0	-1
29	12/02/2022 3:00	0.97	0	0
30	12/02/2022 4:00	0.57	0	1
31	12/02/2022 5:00	0.63	0	1
32	12/02/2022 6:00	0.57	0	0
33	12/02/2022 7:00	0.58	0	1
34	12/02/2022 8:00	1.03	0	1
35	12/02/2022 9:00	0.64	0	1
36	12/02/2022 10:00	0.73	0	1
37	12/02/2022 11:00	1.33	0	1
38	12/02/2022 12:00	0.73	0	0
39	12/02/2022 13:00	0.7	0	0
40	12/02/2022 14:00	2.93	0	-1
41	12/02/2022 15:00	6.03	0	-1
42	12/02/2022 16:00	3.6	0	0
43	12/02/2022 17:00	0.69	0	0
44	12/02/2022 18:00	0.59	0	-1
45	12/02/2022 19:00	0.97	0	0
Sheet12

Cell Formulas
Range	Formula
G2:H6	G2	=SUMPRODUCT(--(INT($A$2:$A$121)=$F2),B$2:B$121)
I2:I6	I2	=SUMPRODUCT(--(INT($A$2:$A$121)=$F2),D$2:D$121)/SUMPRODUCT(--(INT($A$2:$A$121)=$F2))
F3:F6	F3	=F2+1

 

[hip2b2]

Works perfectly,

10^6 thanks

hip