#1
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculate the most recently entered data in columns? | mreynolds1775 | Excel | 10 | 09-19-2017 11:28 PM |
calculate spreadsheet data | ewso | Excel Programming | 3 | 07-30-2017 07:25 AM |
Quetion if then to find data in a table | curbsidejimmy | Excel Programming | 1 | 01-07-2017 04:31 PM |
VBA Word - Find Specific Table - Prepend & Append Data to Each Cell | jc491 | Word VBA | 3 | 12-02-2015 09:48 PM |
Trying to find a way to calculate subtotals for different sections of an invoice w/ data validation | excerbated123 | Excel Programming | 2 | 02-03-2015 09:28 PM |