Let's say you have the subtotaled sales in column C.
Do you want the percentage value to be the subtotal/total for all companies.

Let's say your subtotals are in C1:C10 (for this example)
In D1, put = C1/sum($c$1:$C$10) and format as a %
If that's not what you want, come back and clarify your request.

"Alicia" wrote in message
...
In column one I have the names of many companies. Each company has
different
sales amounts. so each company is listed more than once (each company may
be
listed a different amount of times, depending on the number of sales) I
have
sales subtotaled for each company. In the next column over I would like to
calculate the percentage of a value compared to the subtotal. i need to
do
this for each group. I could do this if there were the same number of
sales
for each company, but how do I create a formula to do this when there are
different numbers of values?