Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |