Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Percentage of Total
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Percentage of Total
Try
=SUM(A2:A4)/SUM(A2:B4) Format as % Mike "macaskillh" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Percentage of Total
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Percentage of Total
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. -- Thanks, Shane Devenshire "macaskillh" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting #DIV/0! when calculating percentage | Excel Worksheet Functions | |||
calculating percentage | Excel Discussion (Misc queries) | |||
Calculating Percentage | Excel Worksheet Functions | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Calculating percentage | Excel Worksheet Functions |