Count comma separated value with one of criteria in between commas

[joonpr]

Sum	1-Jan	2-Jan	3-Jan	4-Jan	5-Jan	6-Jan
?	HQ5	HQ1	HQ1	LQ1	LQ3	LQ2

<tbody>
</tbody>

HQ=High quality
LQ=Low quality

Hi, I have a gantt chart that I log how many high-quality products and low-quality products that are produced per day. How do I keep the get a sum with a criteria for each, "HQ", and "LQ" to differentiate the sum for each? I want the cell to contain the HQ, and the number of product together in one cell.

The reason I need the HQ or LQ label in the cell is to conditionally format the days with HQ and LQ entries.

Is there a way to count if I were to separate the cell content using commas? HQ,5 and what would be the formula to count it?

 

[Peter_SSs]

Welcome to the MrExcel board!

Not certain I have understood what you want but if this, copied across to B2, does what you want.

Excel Workbook
	A	B	C	D	E	F	G	H
1	HQ	LQ	1-Jan	2-Jan	3-Jan	4-Jan	5-Jan	6-Jan
2	7	6	HQ5	HQ1	HQ1	LQ1	LQ3	LQ2
SUM