Count of total visit for different categories

[kashish]

If there is different places with categories A,B,C which is given in B
column from B2.
In row from C2 to N2 months name are given
Every month there is some visit written only in form of DD if there is 2 or
3 visits in same month it is separated by comma
So I want a formula for total no. of visit done for different categories
A,B,C -----
My data is something like as below
Place Category Jan Feb Mar Apr
ABC A 1,2 3 11,12 3
BCA B 5 2 3 3
CAB C 30,31 2 5 5,2
YZX C 1 2 10 15
ZYX B 3 17,25 24 24
XYZ A 17 20 9,10 5

 

[Jarek Kujawa]

with H1=a, H2=b, H3=c
total from Jan till April will be:

=SUMPRODUCT((B1:B6=H1)*(LEN(C1:F6)-LEN(SUBSTITUE(C1:F6,",",""))+1))

then drag/copy down

HIH