Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate percentage of values of subtotals
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
How do I formula a percentage with text values in the data field | Excel Worksheet Functions | |||
Calculate percentage based on cells with conditional formatting | New Users to Excel | |||
calculate percentage | Excel Worksheet Functions | |||
Second serie doesn't use X-as values | Charts and Charting in Excel |