Counting with COUNTIF

Hi,

so here is the problem. According to the given data I am supposed to calculate the number of calls for each
minute in the Busy hour(60 minutes) using "COUNTIF" function in excel.

Arrival time Ta [s]
2
4
7
8
12
16
28
35
44
53
57
58
64
66
68
71
73
75
78
82
84
85
87
88
95
98
101
102
103
104
105
114
115
117
118
119
125
129
130
131
132


sum Ts + Ta; Call ending in seconds
98
82
187
170
132
22
82
191
200
107
75
172
232
90
140
125
223
237
246
190
252
139
261
130
119
128
179
276
133
116
201
252
295
297
280
281
203
141
202
287
138


For example - if I take minute number 2 (between 60-120 seconds), I need to count the calls that started in minute
nr.1 and "reach" minute nr.2 + the calls that started in 2nd minute. That is for example call number 1, 2, 3, 4, 5 but not number 6.
Beginning of each call is "Arrival time Ta" in seconds, and the calls end is "Sum Ts(service time) + Ta".
Same thing is for minute 3, 4, 5 and so on.

Any leads, ideas... Thank you.

is this a homework assignment?

Rule 08: Cross-posting Without Telling Us

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

No further help to be offered, please, until the OP has complied with this request.