MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Formula

Posted by Charlene on January 11, 2002 2:45 PM

I started a mushroom growing business and I need to keep track of the amount of mushrooms off of each bag.Example 4lb. 6 5/8oz. I need to also keep track of the total picked daily. I have been doing this long hand but would like excel to total everything up. Can anyone help.

Posted by Proteus on January 11, 2002 4:03 PM

See if this helps :-

Format columns A & C as Number>General
Format column B as Number>Custom># ??/??
Input your lbs into column A (starting at A1)
Input your oz into column B (starting at B1)
Enter the following formula into C1 and fill down
(this will give the cumulative totals in column C)

=SUM(A$1:A1)+INT(SUM(B$1:B1)/16) & " lb. " & MOD(INT(SUM(B$1:B1)),16) & " " & TEXT(SUM(B$1:B1)-INT(SUM(B$1:B1)),"??/??") & "oz."

Posted by Proteus on January 11, 2002 4:18 PM

Note ...


When inputting your oz, for example 6 5/8, you can input by pressing :-
6 spacebar 5 slash 8 enter