View Single Post
  #1   Report Post  
Randy Mis Randy Mis is offline
Junior Member
 
Posts: 6
Default Sumif between 2 numbers

I am trying to create a sumif which will add numbers which are between two ranges. Here is the data:

On Time 160
1 day late 4
2 days late 3
3 days late 2
4 days late 3
6 days late 5
7 days late 2
8 days late 1
10 days late 2
11 days late 1
12 days late 4
13 days late 2
14 days late 6
15 days late 1
16 days late 2
17 days late 1
20 days late 2
21 days late 3
22 days late 1
26 days late 1
28 days late 1
29 days late 2
30 days late 1
31 days late 1
34 days late 1
45 days late 1
65 days late 1


I would like to break the infor down into weeks, so in week one I would have 19 late.

Any thoughts?