Hi,
I want to determine the amount of sales units that will land in a certain hour of a 24 hour day and sum those units over a range of hours.

Example:

Time Period to sum:

Cell C1:0100
Cell C2:0400

A B
Hour Units Sold
0000 5
0100 5
0200 5
0300 5
0400 5
0500 5

The answer to this would be 15. I feel like I could just do a =sumif(A:A,">=C1",B:B)+sumif(A:A,"<=C2",B:B) or something like that but I can't get it to work.

Thanks!