ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help (https://www.excelbanter.com/excel-worksheet-functions/200880-help.html)

huskym1025

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!

JMB

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!

Gord Dibben

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!

JMB

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!

All times are GMT +1. The time now is 02:00 AM.