Pounds and ounces ???

I would like to format cells as weights and proceed to total the ounces in those cells to equal a pounds and ounces value but I can't find any reference to weights. Is this possible?

Thanks.

If your cells only contain amounts in ounces then you can use the following formula to convert to pounds and ounces.

=ROUNDDOWN(sum(cellrange)/16,0) &"lbs "&MOD(sum(cellrange),16)&"ozs"

Not sure if this helps.

-Alan