Averaging values in subfields of pivot table; or on a list of randomly sequenced data

[jarrgonn]

I've tried querying this dilemma for the past few days but didn't get a response so I decided to ask it here again.

I'm trying to average individual scores/grades depending on the Work Difficulty level graded to them for specific Work Types. One Person [or others] may be assigned with the same Work Type but be graded differently for Work Difficulty; alternatively, one Person may be graded with Work Difficulty differently with the same Work Type.

I have provided [manually computed] the desired score for Persons 1, 5 & 6. Notice Persons 5 where he did the same Work Type [WT5] twice and was coincidentally grade the same Work Difficulty level; while with Person 6, he did the same Work Type [WT7] but was graded differently for both. Ultimately, the Count [if Work Type is done more than once] should FIRST be multiplied with the Work Difficulty level THEN averaged with the other Work Difficulty grades done.

The attached sample file has a minor edit under Person 6.

[AliGW]

Administrative Note:

Unfortunately, this is ANOTHER duplicate thread, and as you have already been told, you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...fficulty.html#