| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help
I need a formula that will take the amount of "ounces" I put in one
range of cells and in another range of cells I need the "ounces" to be totaled. Like this... amount total A1 9 oz 9 oz A2 10 oz 1 lb. 3 oz Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help
you could try:
=INT(SUM(A$1:A1)/16)&" lbs "&MOD(SUM(A$1:A1),16)&" ozs" "huskym1025" wrote: I need a formula that will take the amount of "ounces" I put in one range of cells and in another range of cells I need the "ounces" to be totaled. Like this... amount total A1 9 oz 9 oz A2 10 oz 1 lb. 3 oz Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help
Very good JMB
I would add a test for "" for yet-to-be-filled cells. =IF(A1="","",INT(SUM(A$1:A1)/16)&" lbs "&MOD(SUM(A$1:A1),16)&" ozs") Gord Dibben MS Excel MVP On Sun, 31 Aug 2008 20:31:02 -0700, JMB wrote: you could try: =INT(SUM(A$1:A1)/16)&" lbs "&MOD(SUM(A$1:A1),16)&" ozs" "huskym1025" wrote: I need a formula that will take the amount of "ounces" I put in one range of cells and in another range of cells I need the "ounces" to be totaled. Like this... amount total A1 9 oz 9 oz A2 10 oz 1 lb. 3 oz Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help
Good call.
"Gord Dibben" wrote: Very good JMB I would add a test for "" for yet-to-be-filled cells. =IF(A1="","",INT(SUM(A$1:A1)/16)&" lbs "&MOD(SUM(A$1:A1),16)&" ozs") Gord Dibben MS Excel MVP On Sun, 31 Aug 2008 20:31:02 -0700, JMB wrote: you could try: =INT(SUM(A$1:A1)/16)&" lbs "&MOD(SUM(A$1:A1),16)&" ozs" "huskym1025" wrote: I need a formula that will take the amount of "ounces" I put in one range of cells and in another range of cells I need the "ounces" to be totaled. Like this... amount total A1 9 oz 9 oz A2 10 oz 1 lb. 3 oz Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
