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