Breakdown on columns and matching

[IoanaStanescu]

Hi guys

Really need your help here, please.

need to do a breakdown on products per column (from a cell with multiple products)
need to add "1" each time we can find one of the products from the cell is matching the column header product
Added a sample, as I have a hard time explaining.

Thanks so much!

[samba_ravi]

c12=SUM(COUNTIF($B12,{"";"*,"}&C$11&{"",",*"}))
Try this, copy and paste across