Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula for summing using figures from adjoining rows
I have road milepoints and the number of accidents at that milepoint in
format listed below. What I need to do is find the 10-mile stretch of road with the most accidents. How do I have Excel go through and take a number from the left column and sum all the accidents within a 10-mile range? 141 1 142 1 143 1 146 1 147 1 149 1 151 1 155 1 158 1 159 1 161 1 163 1 166 2 167 3 167 1 173 1 175 1 175 1 175 1 177 1 178 1 179 1 180 1 180 1 180 1 182 1 183 1 185 1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I hide rows in Excel 2002 using a formula in a cell? | Excel Discussion (Misc queries) | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Updating rows - Excel Formula or Something Else? | Excel Worksheet Functions | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |