# 3 dimensional aggregated Average

#### audunoslo

##### New Member
Hi,

I am working with survey feedback, and want to aggregate the reponse

Questions hierarchy.
Main category 1 Sub category 1 Question 1
Main category 1 Sub category 1 Question 2
Main category 1 Sub category 1 Question 3
Main category 1 Sub category 2 Question 4
Main category 1 Sub category 2 Question 5
Main category 2 Sub category 3 Question 6
Main category 2 Sub category 3 Question 7
Main category 2 Sub category 4 Question 8
Main category 2 Sub category 4 Question 9

The response form is in the form
Respondent 1 question 1 xxxx
Respondent 1 question 2 xxxx
Respondent 1 question 3 xxxx
....
Respondent 2 question 1 xxxx
Respondent 2 question 2 xxxx
Respondent 2 question 3 xxxx
....
...
...

I want to be able to sum up the average answer at each question, then find the average between each the questions under the sub category. Before finding the average of the sub categories within each Main Category.

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

#### audunoslo

##### New Member
Forgot the last part of the challenge - There is multiple (Employees belonging to a company) Respondent 1, Respondent 2, etc. where the average among them needs to be calculated first.

##### MrExcel MVP
Post a small sample of the scaled-down problem (reduce number of questions, reduce subcategories, and main categories).

#### audunoslo

##### New Member
Thank you for your response. The attachment will lead to a file with all relevant tables used in process. The original excel workbook has only one table per sheet The challenge is to create the averages of the averages average without copy pasting tables. For example table 3 and 4. The problem gets more challenging when the companies are split into categories, and a new level of average is created.

https://www.dropbox.com/s/o8k0l57xd745o46/ExcelQuestion-average of average.xlsx?dl=0

I strongly appreciate all help I can get. It is my understanding that the problem can be solved with aggregation, but I am struggling with how to add all the layers required.

Replies
2
Views
136
Replies
1
Views
986
Replies
2
Views
1K
Replies
0
Views
382
Replies
2
Views
198

1,126,911
Messages
5,621,595
Members
415,847
Latest member
AlpinoHirsch

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back