Separate Column Inputting Pivot Table Rows Based On "/" Delimiter With Adjacent Range Filter

[whereswaller]

Hi,
I am trying to create a table that summarises the number of times a name appears in a range (in this case an entire column, A:A) that has delimiter (in this case a forward slash) structured data and is filtered by the contents of an adjacent range (in this case an entire column, B:B, where the cell = "Open").

Example dataset
Tiger Woods / Greg Norman	Open
Greg Norman	Open
Tiger Woods / Ernie Els	Closed
Ernie Els / Greg Norman / Tiger Woods	Open
Example desired output
Greg Norman	3
Tiger Woods	2
Ernie Els	1

<tbody>
</tbody>

Is there any way I can achieve this?

Note, the names in the dataset can change so I would like to avoid hardcoding the names and simply using a COUNTIF function to achieve the output.

Many thanks for any help you can provide,
James