How to find data in table to calculate yield
Hello,
I would like to calculate a total yield based on values in a table. It only has to be calculated between the PFB frozen and DPC thaw of the same batch.
Is it possible to set a formula after each row like (=if(C2="PFB frozen", than [my problem],"").
In this way, only a total yield is calculate after the PFB frozen line, no others.
I have attached my file. Table is growing, since it is linked to a sharepoint in which data is added daily.
So:
In the attachment I would like to calculate the yield by dividing J9 (PFB frozen) by G2 (DPC thaw). Both are of the same batch (908682 in column B).
Hope it is possible and many thanks in advance.
Martin
|