HELP!!!! I need to sum and get averages of data with varying

[wi_guy]

The data may look like this:

SKU Region #s sold

100 1 1000
100 2 5000
100 3 4000
101 1 3000
102 2 500
102 5 500
103 1 1000
103 2 1000
103 4 3000

I need it to calculate the pct of total for each SKU.....first I can subtotal by SKU to get the totals, but then I'd have to manually add a column of formulas to calculate %

Final data would look like this

SKU Region #s sold Pct of SKU

100 1 1000 10%
100 2 5000 50%
100 3 4000 40%
101 1 3000 100%
102 2 500 50%
102 5 500 50%
103 1 1000 20%
103 2 1000 20%
103 4 3000 60%

[Mark W.]

With your data in A1:C10 enter the formula, =C2/SUMIF($A$2:$A$10,A2,$C$2:$C$10), into D2 and copy down to D10. Format D2:D10 as 0%

[wi_guy]

THANKS A LOT MARK, WORKED LIKE A CHARM!!!!!