Calculate percent
 

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 Lbs
Carrots 4.0 "
Oatmeal 10.0 "
Total 19.0

In the column next to the weights I want percent.

Thanks

ruko

--
Ruko

Calculate percent
 

you write in the next cell for examplefor cell Celery 5.0 lbs you write in
the next cell =5/19 (which is the total of the weight.), and so on for each
item.

Let me know if this helps.





"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 Lbs
Carrots 4.0 "
Oatmeal 10.0 "
Total 19.0

In the column next to the weights I want percent.

Thanks

ruko

--
Ruko

Calculate percent
 

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 Lbs
Carrots 4.0 "
Oatmeal 10.0 "
Total 19.0

In the column next to the weights I want percent.

Here's one way.

Put the ingredients in column A and the corresponding weights in column B.

In C1, put
=B1/SUM(B:B)
and copy down as far as needed.

Format column C as a percentage.