Division between two different lines and cell

[hendricksk]

Is there a way to divide cells from different lines and rows? I was to divide EBITDA $/day 298 by Eggs - Ave oz/day 41. The result should be 7.26.

Products   $/oz         ave oz/day     $/day           $/month
Cake         76            39                  3043           94342
Eggs          76           41                  3199           99178
Icing          97.7        23                   2294          71123
Pudding    106         16                  1732            53703
EBITDA      7.12                            298              9262

I tried a nested IF Then statement but is in error.

IF StartsWith([Products], "EBITDA") THEN (ToNumber([k$/Day]/ StartsWith([Products], "Eggs")[ave oz/day])) ELSE " " ENDIF

[griffinwelsh]

@hendricksk Easiest way to approach this is to use the transpose and cross tab tools for your calculations. See the attached solution

[hendricksk]

Thank  you!

[griffinwelsh]

@hendricksk please mark this thread solved if my solution works for your usecase.