Agoogirl,

As an academic exercise, with the data in G1:G12 in the form that you gave
(ie 6.02 etc.) then

=INT(SUM(INT(G1:G12))+SUM(MOD(G1:G12,1)*100)/16)+MOD(SUM(MOD(G1:G12,1)*100),
16)/100

entered as an array formula by pressing Control + Shift + Enter intead of
just enter will give you the answer you seek but I do not recommend it - go
with Earl's solution.

Regards

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"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?