Counting String according to row

[halfsparrow]

Hello

I am working on a project and first step was to count the number of Particular floors user enters in the textbox

now i want to check if its is (DSC, DSC-ED, DSC-FA) (DSC, DSC-ED, DSC-FA these are same just different names) or (DSC-ERV, DSC-HRV and this both are same as well just different names) from column I for the each entered floor



what i mean here is if the user entered L2 it shows me the total count of L2 in a particular sheet now i want to check for each L2 weather it is (DSC, DSC-ED, DSC-FA) or (DSC-ERV, DSC-HRV ) from column I and then display the total number of DSC and total number of DSC-ERV in that floor. (DSC-ED, DSC-FA comes under DSC so you can count them or treat them as dsc) (DSC-HRV comes under DSC_ERV so you can treat it as DSC-ERV)



I have attached the file i am using.

i am not able to attach demo excel sheet here but i have attached a ss that will help you to understand and Manufacturing breakdown is the macro enabled sheet.



If you can please help me with this?

Thank-you