Formula help - sum data from hours to date

[LBendix]

I need to sum hourly registration per category (T, S, C, U) on the actual date (see the full dataset attached). Any code help in the attached Excelfile is appreciated!

Lars

-------------

EXAMPLE:

This is how I want my result:

Date	T	S	C	U	Total
2021-07-06	57	17	0	4	78

(Data per hour on that date)

Date	Hour	T	S	C	U	Total
2021-07-06	0:00	0	0	0	0	0
2021-07-06	1:00	0	0	0	0	0
2021-07-06	2:00	0	0	0	0	0
2021-07-06	3:00	1	2	0	0	3
2021-07-06	4:00	1	1	0	0	2
2021-07-06	5:00	2	2	0	0	4
2021-07-06	6:00	3	0	0	0	3
2021-07-06	7:00	7	0	0	0	7
2021-07-06	8:00	4	2	0	0	6
2021-07-06	9:00	4	0	0	0	4
2021-07-06	10:00	7	2	0	0	9
2021-07-06	11:00	5	1	0	0	6
2021-07-06	12:00	5	1	0	0	6
2021-07-06	13:00	2	0	0	0	2
2021-07-06	14:00	0	0	0	0	0
2021-07-06	15:00	1	0	0	0	1
2021-07-06	16:00	3	2	0	1	6
2021-07-06	17:00	5	2	0	0	7
2021-07-06	18:00	3	2	0	1	6
2021-07-06	19:00	2	0	0	2	4
2021-07-06	20:00	2	0	0	0	2
2021-07-06	21:00	0	0	0	0	0
2021-07-06	22:00	0	0	0	0	0
2021-07-06	23:00	0	0	0	0	0

[#2]

@LBendix 

=SUMPRODUCT(($I2=$H$2:$H$2729)*(J$1=$C$1:$F$1)*$C$2:$F$2729)

Maybe with SUMPRODUCT. I've added a (hidden) helper column H which has dates in the format "03.07.2021" instead of "03.07.2021 07:00:00".

[#3]

Thank you, this solved it!