Using SUMIF for multiple values separated by comma??

[HockeyDiablo]

I will have column information that will list entries like this:
DD, DD9, SD, LHR, HIGHLIFT
BOTTOM SECTION, DD, D9
DD, PVC DD, SD, LHR, HIGHLIFT

Is there a way to run a SUMIF or other formula on these and separate the values from the commas? I am familiar with Text to Columns but I will be using 22 unique values "DD, DD9..."

DD	0.3
DD9	0.5
SD	0.8
LHR	1.3
HIGHLIFT	1.5
BOTTOM SECTION	2

<colgroup><col><col></colgroup><tbody>
</tbody>

So the outcome would look something like this.

DD, DD9, SD, LHR, HIGHLIFT 4.25
BOTTOM SECTION, DD, D9 2.75
DD, SD, LHR, HIGHLIFT 3.75

Appreciate it.

 

[njimack]

The below has 2 similar options. Personally I'd go with SUMPRODUCT.

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	DD	0.3
2	DD9	0.5
3	SD	0.8
4	LHR	1.3
5	HIGHLIFT	1.5
6	BOTTOM SECTION	2
7
8
9
10		4.4	4.4		DD	DD9	SD	LHR	HIGHLIFT
11		2.3	2.3		BOTTOM SECTION	DD
12		3.9	3.9		DD	SD	LHR	HIGHLIFT
Sheet1

 

[Marcelo Branco]

Welcome to Mr Excel

Maybe this

	A​	B​	C​	D​	E​
1​	Code​	Value​		Codes​	Total​
2​	DD​	0,3​		DD, DD9, SD, LHR, HIGHLIFT​	4,4​
3​	DD9​	0,5​		BOTTOM SECTION, DD, DD9​	2,8​
4​	SD​	0,8​		DD, SD, LHR, HIGHLIFT​	3,9​
5​	LHR​	1,3​
6​	HIGHLIFT​	1,5​
7​	BOTTOM SECTION​	2​

Formula in E2 copied down
=SUMPRODUCT(--ISNUMBER(SEARCH($A$2:$A$7&",",D2&",")),$B$2:$B$7)

Hope this helps

M.

 

[HockeyDiablo]

That absolutely worked for me. Now testing time. Thank you so much for your time in helping me with this.