I have the following data, but much longer. What I want to do is take the average of the total summed hours. I have categories with sub categories with sub categories below that. In the pivot example below when I select average it averages by person. What I want is the average by the total amount of hours by Bar while having the names on the pivot. So instead of 27.946 average by name I would like the average of the bars 125.76 (140.33+111.19)/2.
Maybe I have to add another column to the raw data, but if I do a sumif, averageif, or countif etc. it will have duplicates.
<tbody>
</tbody>
<tbody>
</tbody>
Maybe I have to add another column to the raw data, but if I do a sumif, averageif, or countif etc. it will have duplicates.
<tbody>
</tbody>
| Row Labels | Manufacturing |
| Soap | 251.52 |
| Bar 1 | 140.33 |
| Tim | |
| Jim | |
| Jon | 21.91 |
| Sebby | 118.42 |
| Ralph | |
| Bar 2 | 111.19 |
| Ralph | |
| Sebby | |
| Tim | 67.76 |
| Jon | 43.43 |
<tbody>
</tbody>
Last edited:
