yogi_Get Count Of 'Work Codes' Withe Multiple 'Work Codes' Entered Per Row IIn Sheet Named 'Invoices'

Google Spreadsheet   Post  #2466

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jun-28-2018

question by: Mindi Bishop
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/Jr3IhjcPABQ;context-place=forum/docs
How to count multiple values
Hello!

I have a worksheet where on the "Invoices" sheet, there is a column that has Work Code letters.  Some are single letters, others are multiple. 

Invoice #	Work Code
18002	A
18003	F
18004	I
18005	G,E
18006	C
18007	F,B

 Then there is a "Work Code" sheet where I would like to count how many times each Code is used.  

Work Code	Work	Totals
A	Add Gore	1
B	Button	0
C	Patch Hole	1
D	Alter Sides	0
E	Elastic Replaced	0
F	Figment Costume	1
G	Hem Pants	0
H	Hem Skirt/Dress	0
I	Hem Sleeve	1

I am using this formula to count the work codes.  =COUNTIF(Invoices!$C:C,"A")

But as you can see, it does not recognize the cells that have multiple values in them.  

Can someone help me out?

Thank you!