K
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 -----i.e. Total no.visit of A, Total
no.visit of B, Total no.visit of C
My data is something like as below
-----------------------------Jan---------Feb--------Mar--------Apr
Place-------Category
ABC---------A---------------1,2--------3----------11,12--------3
BCA---------B----------------5----------2----------2------------3
CAB---------C----------------30,31-----2----------5------------5,2
YZX---------C----------------1----------2----------10-----------15
ZYX---------B----------------3----------3----------17,25--------24
XYZ---------A----------------17--------20----------9,10--------5
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 -----i.e. Total no.visit of A, Total
no.visit of B, Total no.visit of C
My data is something like as below
-----------------------------Jan---------Feb--------Mar--------Apr
Place-------Category
ABC---------A---------------1,2--------3----------11,12--------3
BCA---------B----------------5----------2----------2------------3
CAB---------C----------------30,31-----2----------5------------5,2
YZX---------C----------------1----------2----------10-----------15
ZYX---------B----------------3----------3----------17,25--------24
XYZ---------A----------------17--------20----------9,10--------5