If you already have the totals in A,B,C

Lost: = B2/A2
In Production: = A2/C2

both formatted as percentage

If you have just job details, assuming that row is headings then

Lost =(COUNTA(B:B)-1)/(COUNTA(C:C)-1)
In Production: =(COUNTA(A:A)-1)/(COUNTA(C:C)-1)

again formatted as percentage

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nigel" wrote in message
...
Hi,
Can anyone help me? i need to find a percentage which is described in the
following:

Quotation per year
Work Lost
Work in production.

i have 3 columns as above.
column 1 contains all quotes to date
column 2 contains all work lost to date
column 3 contains all work in production to date.

i need to create 2 figures.
1 figure to show percentage of quotes lost to date
1 figure to show percentage of quotes in production to date
example:-
55 quotes to date
7 quotes lost
48 quotes in production

therefore 3.85% quotes lost
96.15% quotes in production

this needs to calculate a range of cells containing text to count between
amount of jobs quoted, amount of jobs lost and amount of jobs in
production.

i konw its a bit lengthy but can anyone help me to complete this task s i
have to get it finished pronto.


thanks,

nige