Agoo,

One way is to put the pounds in one column (say A), and the ounces in
another (say B). Sum them with:

For the pounds: =INT(SUM(A2:A10) + SUM(B2:B10)/16)
For the ounces: =MOD(SUM(A2:A10) + SUM(B2:B10)/16,1)*16

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Agoogirl" wrote in message
...
I need to keep a running total of weight, in pounds and ounces, for 12
months. I'd like to add 6.02 (6lbs 2ozs), 9.13 (9lbs 13 ounces)etc and be
able to total 12 different numbers. How do I get the number to recognize
16ozs as 1 pound? Is there a better way?