Count comma separated value with one of criteria in between commas

[joonpr]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sum[/TD]
[TD]1-Jan[/TD]
[TD]2-Jan[/TD]
[TD]3-Jan[/TD]
[TD]4-Jan[/TD]
[TD]5-Jan[/TD]
[TD]6-Jan[/TD]
[/TR]
[TR]
[TD]?[/TD]
[TD]HQ5[/TD]
[TD]HQ1[/TD]
[TD]HQ1[/TD]
[TD]LQ1[/TD]
[TD]LQ3[/TD]
[TD]LQ2[/TD]
[/TR]
</tbody>[/TABLE]

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