Hi,
I wondering if it possible to write a formula to count down a column, looking for the next occupied cell and the summing up the cells in another column.
Example:
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup>
So, what i essentially need is to look down column 'A' detect the next value, but then sum up the detail in column 'H'. Current Formula I have in column 'N' is =ISNUMBER(A3)*(SUM($H$2:H3))
Any help would be appreciated
Many Thanks
Mick
I wondering if it possible to write a formula to count down a column, looking for the next occupied cell and the summing up the cells in another column.
Example:
Route | Delivery Sequence | Store Name | Store Reference | Depart Depot | Planned Cages | System Priority | System Trailer Number | DHL Trailer Number | Bay Number | Trailer Capacity | Route Planned Cages |
2 | METRO CENTRE (3353) | 3353 | 59 | ||||||||
1 | 1 | NEWCASTLE (1300) | 1300 | 04:45 | 61 | 9500 | STR1 | 58 | 0 | ||
2 | CHESHIRE OAKS (0399) | 0399 | 19 | ||||||||
2 | 1 | CHESTER (1245) | 1245 | 07:11 | 20 | 9400 | STR2 | 54 | |||
4 | WARRINGTON (1517) | 1517 | 90 | ||||||||
3 | OSWESTRY SF (4255) | 4255 | 65 | ||||||||
2 | HESWALL SF (5827) | 5827 | 38 | ||||||||
3 | 1 | PRESTATYN (0176) | 0176 | 07:29 | 66 | 9300 | STR3 | 58 | |||
4 | 1 | GEMINI (2781) | 2781 | 08:55 | 31 | 9200 | STR4 | 58 |
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup>
So, what i essentially need is to look down column 'A' detect the next value, but then sum up the detail in column 'H'. Current Formula I have in column 'N' is =ISNUMBER(A3)*(SUM($H$2:H3))
Any help would be appreciated
Many Thanks
Mick