How to find data in table to calculate yield

mwestra74 · #1 11-28-2017, 06:40 PM

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