|
|
#1
03-17-2017, 05:56 PM
|
|||
|
|||
Need Multiple Formulas Pulled from a data chart
Job Ty Dept 1 Dept 2 Margin
Internal Person A Person 1 24.00% Internal Person B Person 2 10.00% External Person C Person 3 25.00% External Person D Person 4 15.00% External Person E Person 5 10.00% I have an excel chart like above and I need to pull multiple items from the chart and have it calculate the averages. So First off I will need a formula to total the Internal Jobs and then Average, External Jobs then Average. Secondly I need to get the average margins for each individual in Dept 1 and the same average for the personnel in dept 2. Is there a formula or chart I can create to pull the margins just for each individual? 
|
|
#2
03-20-2017, 07:42 AM
|
|||
|
|||
|
Quote:
|
|
| Tags |
| excel 2016 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| need help! broken column & bar chart for multiple categories of data | elguapoyo | Excel | 0 | 01-23-2017 08:51 PM |
| Using multiple formulas in one (IF, AND and SUM) gives syntax error | markdeniet | Word | 1 | 02-05-2014 05:17 AM |
 Multiple Formulas in one Cell one Formula Away From Completion
|
microsoftnovice | Excel | 2 | 12-05-2012 12:54 PM |
| Being pulled by opposing powers. How? | PPT | PowerPoint | 2 | 04-25-2012 09:50 AM |
| If/then formulas with data validation | shira47 | Excel | 1 | 04-09-2012 05:14 AM |
Windows 10 
Office 2016
Linear Mode
