Open the Excel workbook
- Highlight Cell A1
- Press Ctrl+Shift+End to highlight all the data
- Click Insert
- Select Pivot Table
- Click OK to accept the default settings
![](https://media.screensteps.com/image_assets/assets/004/681/803/original/1deb798f-99ad-4874-9601-252707119ba8.png)
- Select the following Pivot Table Fields:
![](https://media.screensteps.com/image_assets/assets/004/681/805/original/c5d51bd7-6c37-475f-999f-d8cf9a12a68d.png)
- In Rows click on vPosition
- Select Move Up
![](https://media.screensteps.com/image_assets/assets/004/681/807/original/b1390ca2-9ddc-493f-8b79-bddbf65f7fd9.png)
Results should show a total for all wages plus a sub total for ‘Position’ wages, plus a subtotal for all 'non position' wages
![](https://media.screensteps.com/image_assets/assets/004/681/809/original/83fb0750-ebf7-4671-bfd8-eeb37852917b.png)
- Repeat for each workbook
- Rename Worksheet names for clarity if desired