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..."


[TABLE="width: 179"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]DD[/TD]
[TD="align: right"]0.3[/TD]
[/TR]
[TR]
[TD]DD9[/TD]
[TD="align: right"]0.5[/TD]
[/TR]
[TR]
[TD]SD[/TD]
[TD="align: right"]0.8[/TD]
[/TR]
[TR]
[TD]LHR[/TD]
[TD="align: right"]1.3[/TD]
[/TR]
[TR]
[TD]HIGHLIFT[/TD]
[TD="align: right"]1.5[/TD]
[/TR]
[TR]
[TD]BOTTOM SECTION[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]

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


[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]

A​

[/td][td="bgcolor: #DCE6F1"]

B​

[/td][td="bgcolor: #DCE6F1"]

C​

[/td][td="bgcolor: #DCE6F1"]

D​

[/td][td="bgcolor: #DCE6F1"]

E​

[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]

1​

[/td][td]

Code​

[/td][td]

Value​

[/td][td][/td][td]

Codes​

[/td][td]

Total​

[/td][/tr]


[tr][td="bgcolor: #DCE6F1"]

2​

[/td][td]

DD​

[/td][td]

0,3​

[/td][td][/td][td]

DD, DD9, SD, LHR, HIGHLIFT​

[/td][td]

4,4​

[/td][/tr]


[tr][td="bgcolor: #DCE6F1"]

3​

[/td][td]

DD9​

[/td][td]

0,5​

[/td][td][/td][td]

BOTTOM SECTION, DD, DD9​

[/td][td]

2,8​

[/td][/tr]


[tr][td="bgcolor: #DCE6F1"]

4​

[/td][td]

SD​

[/td][td]

0,8​

[/td][td][/td][td]

DD, SD, LHR, HIGHLIFT​

[/td][td]

3,9​

[/td][/tr]


[tr][td="bgcolor: #DCE6F1"]

5​

[/td][td]

LHR​

[/td][td]

1,3​

[/td][td][/td][td][/td][td][/td][/tr]


[tr][td="bgcolor: #DCE6F1"]

6​

[/td][td]

HIGHLIFT​

[/td][td]

1,5​

[/td][td][/td][td][/td][td][/td][/tr]


[tr][td="bgcolor: #DCE6F1"]

7​

[/td][td]

BOTTOM SECTION​

[/td][td]

2​

[/td][td][/td][td][/td][td][/td][/tr]
[/table]

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.