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