Hi,
Assuming it starts in row 2
in D2:
=IF(UPPER(RIGHT(A2,6))=" TOTAL","",B2/VLOOKUP(A2&" TOTAL",$A:$B,2,FALSE))

--
Regards,
Sébastien


"jtoy" wrote:

I could do this manually, but it would take me forever. Is there a
program/formula that could be written to automatically find the Individual
Job percentages - column C?? The variable to this equation is that the number
of Individual Jobs varies. And how to refer to the correct company total?

-------------
Column A = Company Name
Column B = Total Sales amount for the company followed by Individual Job
amounts (which add up to the Total Sales). The number of Individual Jobs can
vary.
Column C = Individual Job percentage of the company's Total Sales. See the
example below.

A B C
XYZ Total 485,000
XYZ 265,000 55%
XYZ 150,000 31%
XYZ 55,000 11%
XYZ 15,000 3%
ABC Total 800,500
ABC 500,000 62%
ABC 300,000 37%
JKL Total 1,400
JKL 500 36%
JKL 400 29%
JKL 300 21%
JKL 200 14%
JKL 100 7%
JKL 50 4%

Thank you in advance!!