# SUM a sequence

#### Sanjin

##### New Member
Hello everybody,

I am desparately looking for a solution to my problem.

I somehow need to apply this formula to a sequence of cells (for example) =SUM(ROUNDUP(A1/2;0);ROUNDUP(A2/2;0);...;ROUNDUP(An/2;0)).

Is there a way to insert this automatically, and not one by one?

I am trying to sum the number of packages needed for all orders. Usually, two products are shipped in one packaging, but it is possible to order only one product, and in that case it is, obviously, shipped in one packaging. And that formula above would solve that problem, if only I could enter it automatically.

The only solution I could think of, is to make a new column in which I would calculate this part ROUNDUP(A1/2;0) and then just sum everything later on.

Thank you in advance for your help.

Regards,
Sanjin

Last edited:

### Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### pgc01

##### MrExcel MVP
Hi Sanjin
Welcome to the board

Try, for ex. for values in A1:A10:

=SUMPRODUCT(ROUNDUP(A1:A10/2,0))

#### Sanjin

##### New Member
Hi Sanjin
Welcome to the board

Try, for ex. for values in A1:A10:

=SUMPRODUCT(ROUNDUP(A1:A10/2,0))

Thank you @pgc01.

You've solved it. Thanks.

#### pgc01

##### MrExcel MVP
You're welcome. Thanks for the feedback.

Replies
7
Views
2K
Replies
15
Views
626
Replies
29
Views
3K
Replies
1
Views
373
Replies
1
Views
244

1,190,616
Messages
5,981,956
Members
439,745
Latest member
VBANewbieJohn

### 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

### Which adblocker are you using?

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