I am attaching excel sheet- hopefully i will be abe to explain:
formula is in (mechanic 2008).(cell B13)
i have two worksheets 'mechanic 2008 and company 2008.
you will see i have 75 % of formula working in mechanic 2008. cell B13.
( now I cannot make this work at all for the names jones and doe.)
I have 3 names adams, jones, and doe.
(mechanic 2008).B13 = (company 2008).A1:A16( where = adams) * (company 2008.C1:C16 ( where = on) DIVIDED BY (mechanic 2008.B1)
Problems: I do not know how it is working to get only adams - the way I have it. and cannot get it to work for other names.
Part Cannot Figure out:
I also want to have formula in C13 ( - Only records where (company 2008).L1:L16 = 'new'