Text string extraction

[Excellis]

Can anyone help?
I'm after a function or combination of functions that can help me extract specific text from a known set of variables. For example, from the list below I might want to know how many blue flags are listed. I may also want to know how many white posters are listed etc.
The list (within each cell) will always be in alphabetical order by item, and the colours will always be in alphabetical order within the parentheses, but not all elements will be present at all times, as you can see.
In the list below each line represents a cell so the range could be C7:C22, for example

[TABLE="width: 425"]
<TBODY>[TR]
[TD]Poster (White)</SPAN>[/TD]
[/TR]
[TR]
[TD]Poster (Blue,Red,White), Flag (Red)</SPAN>[/TD]
[/TR]
[TR]
[TD]Leaflet (Red), Poster (Blue), Flag (Blue,White)</SPAN>[/TD]
[/TR]
[TR]
[TD]Card (Red), Sticker (Red), Flag (Blue,Red)</SPAN>[/TD]
[/TR]
[TR]
[TD]Sticker (Blue,Red,White), Bookmark (Blue)</SPAN>[/TD]
[/TR]
[TR]
[TD]Sticker (Red,White), Flag (Blue,White)</SPAN>[/TD]
[/TR]
[TR]
[TD]Sticker (Blue,Red,White), Flag (Blue)</SPAN>[/TD]
[/TR]
[TR]
[TD]Bookmark (Blue), Flag (Blue,Red,White)</SPAN>[/TD]
[/TR]
[TR]
[TD]Leaflet (Blue,Red), Poster (Blue,Red),Flag (Red)</SPAN>[/TD]
[/TR]
[TR]
[TD]Leaflet (Blue,Red,White), Poster (White)</SPAN>[/TD]
[/TR]
[TR]
[TD]Card (Red), Sticker (Red), Flag (Red)</SPAN>[/TD]
[/TR]
[TR]
[TD]Leaflet (Red), Sticker (Red), Flag (Red)</SPAN>[/TD]
[/TR]
[TR]
[TD]Leaflet (Red), Sticker (Red), Flag (Red)</SPAN>[/TD]
[/TR]
[TR]
[TD]Leaflet (Red), Sticker (Red)</SPAN>[/TD]
[/TR]
[TR]
[TD]Card (Blue), Flag (Red)</SPAN>[/TD]
[/TR]
[TR]
[TD]Leaflet (Red), Sticker (Red), Flag (Blue)

Thanks in advance
</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL></COLGROUP>[/TABLE]

 

[Excellis]

Thanks for the welcome, Peter, and thanks for your response.
That works quite well, too.
I'm spoilt for choice now.

Thank you, all.

 

[Biz]

Nice UDFs and nice formula Peter.

Biz