Multiple conditions IF, percentage calculation on a range of cells

Dear community,

It has been hours now since I am trying to solve an issue with a calculation. As you may see on the attached picture.
I am trying to calculate a percentage based on multiple conditions on ranges of cells.

I would like to calculate as follows: If the "item category" is [Fruit] and if there is a number in "Organic surface", then I would like to calculation the % of this specific fruit weight out of the sum of Fruit weight. (in this case 2 tons / (2 + 1 + 0.5) tons).
I would like this formula to be valid for the whole ranges (2 : 12) for all columns.

TEST_Excel.png

I hope I am clear enough,
Many many thanks for your support,
DW

Put this formula in E2:

=IF(OR(A2="-",D2="-"),"",C2/SUMIF($A$2:$A$12,A2,$C$2:$C$12))

Note that you might need to use semicolons ( ; ) instead of commas ( , ) in the formula, depending on your regional settings.

Format the cell as percentage, then copy down to E12.

Hope this helps.

Pete

Many thanks Pete_UK. With the method you proposed, I then sum the percentages in the cell C14 and I get the overall % of organic fruit.
However, what I was looking for is to make the condition on the [Fruit] as well since in column A it may either be [Fruit] or [Vegetable] at the end ...

etaf, I am looking for the percentage of organic Fruit out of the total of fruits. And if a raw in the column "Organic surface" has a number, then it means that the related fruit is organic.