# Calculated Average by Fee Level

#### Datatellsall2

##### New Member
Hello -

I'm trying to calculate a measure where I can see the average number of hours by fee level based on the 'individual'. As an example based on the data below, the average for Person A would be 4 within the 20K fee level.

 Fee Category Individual Name of Project 20000 25000 35000 40000 45000 Person A Project 1 3 Person A Project 2 3 Person A Project 3 5 Person A Project 4 3 Person A Project 5 8 Person A Project 6 3 Person B Project 1 6 Person B Project 2 16 Person B Project 3 7 Person B Project 4 8 Person C Project 5 5 Person C Project 6 6 Person C Project 7 12 Person C Project 8 1 Person C Project 9 13 Person C Project 10 11 Person C Project 11 7

<colgroup><col><col><col span="5"></colgroup><tbody>
</tbody>

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Book1
ABCDEFG
1Fee Category
2IndividualName of Project2000025000350004000045000
3Person AProject 13
4Person AProject 23
5Person AProject 35
6Person AProject 43
7Person AProject 58
8Person AProject 63
9Person BProject 16
10Person BProject 216
11Person BProject 37
12Person BProject 48
13Person CProject 55
14Person CProject 66
15Person CProject 712
16Person CProject 81
17Person CProject 913
18Person CProject 1011
19Person CProject 117
20
212000025000350004000045000
22Person A435.503
23Person B009.2500
24Person C059113
Sheet5
Cell Formulas
RangeFormula
C22=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A22,C\$3:C\$19),0)
C23=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A23,C\$3:C\$19),0)
C24=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A24,C\$3:C\$19),0)
D22=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A22,D\$3:D\$19),0)
D23=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A23,D\$3:D\$19),0)
D24=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A24,D\$3:D\$19),0)
E22=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A22,E\$3:E\$19),0)
E23=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A23,E\$3:E\$19),0)
E24=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A24,E\$3:E\$19),0)
F22=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A22,F\$3:F\$19),0)
F23=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A23,F\$3:F\$19),0)
F24=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A24,F\$3:F\$19),0)
G22=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A22,G\$3:G\$19),0)
G23=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A23,G\$3:G\$19),0)
G24=IFERROR(AVERAGEIF(\$A\$3:\$A\$19,\$A24,G\$3:G\$19),0)

Works perfectly! Thank you!

Replies
4
Views
219
Replies
6
Views
173
Replies
8
Views
126
Replies
9
Views
279
Replies
1
Views
442

1,206,945
Messages
6,075,780
Members
446,156
Latest member
Aaro23

### 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