Calculating Percentage of Total

[macaskillh]

Here is what I'm looking for the Total # Sent & Kept for each line. But also
the percentage of # Sent from the total. Does this make sense.

Example: for the first I'm getting 33% sent vs. kept but what percent of the
total were Sent?

# Sent l # Kept
6,843 13,586
30,915 16,418
129,993 19,292

 

[Mike H]

Try

=SUM(A2:A4)/SUM(A2:B4)
Format as %

Mike

 

[TomPl]

Actually, in the first case 6,843 is 50% of 13,586 (#Kept) and 33% of the
percent of the total.

Assuming your three rows of data are in cells A2:B4, then put the formula
=A2+B2 in cell C2. that will give you the total. Put the formula =A2/C2 in
cell D2. That will give you the percentage of the total that were shipped.
Similar formulas can then be put in cells C3,C4,D3 and D4.

I hope this helps.

Tom

 

[ShaneDevenshire]

Hi,

There is some confusion here, so I'm not sure my formulas meet your need

Suppose you data is in A2:B4, %Sent in column C, %Kept in Column D, and
%Send of Total in column E

C: =A2/(A2+B2)
D: =1-C2
E: =A2/SUM($A$2:$B$4)

Copy these formulas down.

Now the confusion comes when you ask for %sent of total - do you mean
percent of total sent or percent total Sent+Kept. If the first then in E2
enter
=A2/SUM($A$2:$A$4)
In the second case use the formula labled E:
There could also be a third possibility - you want the percent of total sent
to total of all sent and kept, that would be
=A2:A4/SUM($A$2:$B$4)
This last formula would not be copied down.

If this is helpful, please click the Yes button.