You can just highlight your data and on the "Insert" Ribbon On top as shown on your picture you can select the Pivot table. On the left pane Drag the column name Orientation Date on ROWS section of the Pivot, Then drag the different dept on the VALUES section of the pivot, both to the bottom on the pane. This will give you the sum or count of each dept based on the dates. When ever new info is entered then go to the ANALYZE ribbon on top and click "Change data Source" highlight the the relevant information and it will give you the info needed. This should Help.
|