Sum data depending on time?

[Cadderly]

Hello,

I need to sum data between a time period. For example :-
Time Quantity
11:48 134
12:25 152
12:28 121
12:35 143

I need to Sum all quantities that arrived between 12:00 and 12:30. Can anyone help?

Thanks
Cadderly

 

[Aladin Akyurek]

On 2002-10-11 04:34, Cadderly wrote:
Hello,

I need to sum data between a time period. For example :-
Time Quantity
11:48 134
12:25 152
12:28 121
12:35 143

I need to Sum all quantities that arrived between 12:00 and 12:30. Can anyone help?

Thanks
Cadderly

Let A2:B5 house the sample you provided, excluding the labels...

In D2 enter: 12:00

In E2 enter: 12:30

In F2 enter:

=SUMIF($B$2:$B$5,">="&D2)-SUMIF($B$2:$B$5,">"&E2)

will compute the desired sum.

 

[Cadderly]

Thanks for that, works well.