| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
Quote:
Code:
A B C D Day Late Week Total 1 4 1 19 2 3 2 16 3 2 3 9 4 3 4 3 6 5 5 5 7 2 6 0 8 1 7 1 10 2 8 0 11 1 9 0 12 4 10 1 13 2 14 6 15 1 16 2 17 1 20 2 21 3 22 1 26 1 28 1 29 2 30 1 31 1 34 1 45 1 65 1 Code:
=SUMIFS($B$2:$B$28,$A$2:$A$28,"=" & C2*7-6,$A$2:$A$28,"<=" & C2*7) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
