Thursday, June 28, 2018

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
18002A
18003F
18004I
18005G,E
18006C
18007F,B
 Then there is a "Work Code" sheet where I would like to count how many times each Code is used.  
Work CodeWorkTotals
AAdd Gore1
BButton0
CPatch Hole1
DAlter Sides0
EElastic Replaced0
FFigment Costume1
GHem Pants0
HHem Skirt/Dress0
IHem Sleeve1
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!