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