Percent of Total with a break 1

[MSIsam]

Hi,

I have a data set that I would like to create a percent of total on. the hard part for me is to create this with a break.

The example below is a sample with territory number and units. The data is sorted by territory number (asc) then units (desc)

I can get the PctOf Ttl column by using
=SUM(B$2:B2)/SUM(B:B)
Does anyone know how to get the last column? I would prefer to not use VBA but beggers can't be choosers.

Terr Nbr   Units   PctOfTtl    [COLOR=red]PctOfTerr[/color]
006501       100      7.2%        29.4%
006501        90     13.7%        55.9%
006501        80     19.4%        79.4%
006501        70     24.5%       100.0%
006502       200     38.8%        19.0%
006502       190     52.5%        37.1%
006502       180     65.5%        54.3%
006502       170     77.7%        70.5%
006502       160     89.2%        85.7%
006502       150    100.0%       100.0%

Thanks in advance for any help on this,
Sam

 

[macropod]

Hi Sam,

In D2 enter:
=SUMIF(A$1:A2,A2,B$1:B2)/SUMIF(A:A,A2,B:B)
and copy down as far as needed.

Cheers

[MS MVP - Word]

 

[MSIsam]

Perfect! Thanks so much macropod.