Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
dividng numbers using the sumif function | Excel Worksheet Functions | |||
Sumif only numbers formated as currency | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Sumif for lowerst value within limited to 2 numbers only | Excel Worksheet Functions |