# Addition Formula

#### m0ws3r

##### New Member
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:
 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

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
you need to sum the System Trailer Number (column H)?

What should be the result (manualy).

Something like?

=ISNUMBER(A3)*SUM(INDIRECT("\$H\$2:H"&ROW()))

Or:

=IF(ISNUMBER(A3),SUM(INDIRECT("\$H\$2:H"&ROW())),"")

?

Hi Steve the fish,

returns the same

Hi. What returns the same? The two formulas? They are different. They may return the same however. The first will return 0 if A3 is not a number and the 2nd will return "". Or don't I understand what you are after?

apologies, they return to same information as the formula I have,

what i need is the formula to detect the blanks up to a cell with a number in route column, then add the corresponding cells in H columns

example
Route 1 = sum of H2:H3 then count the next set of blank cells up until an occupied cell
Route 2 would be = sum of H4:H5
Route 3 would be = sum of H6:H9

Like this?

Excel Workbook
ABCDEFGHIJ
1RouteSum
21
3134
42
54
65
73
82216
94
103
11329
12411
131
142
15536
Sum

Peter,

there is a word for people like you......awesome

much appreciated

thanks
Mick

Glad it helped. Thank you for the generous feedback.

Replies
0
Views
226

Threads
1,221,522
Messages
6,160,312
Members
451,637
Latest member
hvp2262

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back