Formula to add up units
 

Hello from steved

A bit unusal but this is what I would like to achieve please.

A1, B1, C1, D1, E1, and F1

Ok in G1 I would like a formula that would add up 50 cent amounts
in A1 to F1 an example would be 5*5*5*4*4*1 = $1,000

objective is to put a number in cells A1 to F1 and get a totalin G1

Thankyou.

Thankyou.

in G1
=SUM(A1:F1) will give the total number of 50 cents.
To convert to dollars either divide by ).5 or multiply by 2
=SUM(A1:F1)*2

--
Regards

Roger Govier


"Steved" wrote in message
...
Hello from steved

A bit unusal but this is what I would like to achieve please.

A1, B1, C1, D1, E1, and F1

Ok in G1 I would like a formula that would add up 50 cent amounts
in A1 to F1 an example would be 5*5*5*4*4*1 = $1,000

objective is to put a number in cells A1 to F1 and get a totalin G1

Thankyou.

Thankyou.

Afaik 50 cents is 1/2 dollar, so multiply them and divide by 2:
=PRODUCT(A1:F1)/2
or
=A1*B1*C1*D1*E1*F1/2
depending on how you want empty cells to behave. Format as currency.

HTH. Best wishes Harald

"Steved" skrev i melding
...
Hello from steved

A bit unusal but this is what I would like to achieve please.

A1, B1, C1, D1, E1, and F1

Ok in G1 I would like a formula that would add up 50 cent amounts
in A1 to F1 an example would be 5*5*5*4*4*1 = $1,000

objective is to put a number in cells A1 to F1 and get a totalin G1

Thankyou.

Thankyou.

Thanks very much.

"Harald Staff" wrote:

Afaik 50 cents is 1/2 dollar, so multiply them and divide by 2:
=PRODUCT(A1:F1)/2
or
=A1*B1*C1*D1*E1*F1/2
depending on how you want empty cells to behave. Format as currency.

HTH. Best wishes Harald

"Steved" skrev i melding
...
Hello from steved

A bit unusal but this is what I would like to achieve please.

A1, B1, C1, D1, E1, and F1

Ok in G1 I would like a formula that would add up 50 cent amounts
in A1 to F1 an example would be 5*5*5*4*4*1 = $1,000

objective is to put a number in cells A1 to F1 and get a totalin G1

Thankyou.

Thankyou.