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
Bookmarks