Sum up columns based on values (date and time) in more than one column

[jeffersone]

Hello,

I am having some difficulty writing a formula to sum up data based on the value of two or three other columns. I would like for Excel to sum up total number of participants for a certain exam time on a certain date.
In the example below, on the 2nd of September, I would like to sum up the number of participants for the exam 8:00 - 11:00 hours, 8:00 - 12:00 hours, 14:00 - 17:00 hours och 14:00 - 18:00 hours and so on.

Is there a way to build a formula based on this criteria to get a result like on column H. A VBA is ideal but I am thankful for any suggestions even about a formula. If needed I can have duplicates of the date on each row.

 

[myall_blues]

Unfortunately I can’t use XL2BB at present, but if you fill the dates to each row, then put this formula in H2

=LET(x,UNIQUE(B2:D1000),SORTBY(x,INDEX(x,0,1),1,INDEX(x,0,2),1,INDEX(x,0,3),1))

you will get a spilled array in columns H:J of the unique date/time combinations. Change D1000 in the formula to suit your bottom row.
Then in K2 put the formula

=SUMIFS(G$2:G$1000,B$2:B$1000,H2,C$2:C$1000,I2,D$2:D$1000,J2)

and copy down.

 

[jeffersone]

Unfortunately I can’t use XL2BB at present, but if you fill the dates to each row, then put this formula in H2

=LET(x,UNIQUE(B2:D1000),SORTBY(x,INDEX(x,0,1),1,INDEX(x,0,2),1,INDEX(x,0,3),1))

you will get a spilled array in columns H:J of the unique date/time combinations. Change D1000 in the formula to suit your bottom row.
Then in K2 put the formula

=SUMIFS(G$2:G$1000,B$2:B$1000,H2,C$2:C$1000,I2,D$2:D$1000,J2)

and copy down

Thank you so very much. That did the trick!

 

[myall_blues]

You’re welcome. Thanks for the feedback