Hi
I am trying to create one summary sheet within a workbook that contains 5 sheets.
The 5 sheets are the same layout and contain the same column headings.
On my summary sheet I want to lookup 3 different values:
It would be something like this, so I want to find how many items John has against Finance that are open, active and in progress:
<tbody>
</tbody><colgroup><col><col><col></colgroup>
I am trying to create one summary sheet within a workbook that contains 5 sheets.
The 5 sheets are the same layout and contain the same column headings.
On my summary sheet I want to lookup 3 different values:
It would be something like this, so I want to find how many items John has against Finance that are open, active and in progress:
Status | Open, Active, In Progress | |
Persons name | Department Name | Finance |
John | Count of Finance entries for John where the status is Open, Active, In Progress |
<tbody>
</tbody><colgroup><col><col><col></colgroup>