Oops.. I didn't notice there was a total field. My bad...

"Mike H" wrote:

Assuming weights in column B and total in B4

=B1/$B$4

drag down and format as %

Mike

"Ruko" wrote:

I have a recipe that contains a column of 24 different items with their
weights. I want to calculate the percentages of each of the 24 items and
place the result in the next column. How do I do it? Example: Celery 5.0
Carrots 4.0
Oatmeal 10.0
Total 19.0

In the column next to the weights I want percent.

Thanks

ruko

--
Ruko