Grouping and counting series of time-stamped events

Hello,

I hope somebody can help me with this as I'm stuck on this problem. I've been organizing my data as seen on "data" file. Column A is the Time (per second) when the Event in Column B was observed.

Additionally, there's a series of tagged Intervals (interval 1, interval 2, interval 3 etc.) on column C.

There are 10 different categories of Events.

What I'd like to do is, for each Interval, count the number of times an Event was observed.

Ideally, I would like my transformed data to look like the "output" file. I've left the cells empty but of course they should be filled when the table is ready.

Because there's one Event per second and MOST Intervals (but not all) last for 80 seconds, the total number of counts should then be 80 for the most part. This is accounted for in the column L of the "output" file which is basically a function =SUM(B2:K2).

There's up to 5437 Inervals in the original file but I've only posted until Interval 6 because of size issues.

Any input and help is welcome and thank you very much in advance!

you can do that with countifs or with a pivot table, with the amount of intervals you have I think a pivottable is more helpfull as it will add new info automatic if you set the range correct.

please see attachment for both solutions

Thank you so much I couldn't get a better answer!