SUM a sequence

[Sanjin]

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

 

[pgc01]

Hi Sanjin
Welcome to the board

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

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

 

[Sanjin]

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]

You're welcome. Thanks for the feedback.