Search Range of Cells and Sum Values

[jirpel]

Hi,

I was wondering if there is an easy way to search a group of values and sum the corresponding number listed in the ROW below it.

[TABLE="width: 384"]
<tbody>[TR]
[TD="class: xl69, width: 64"]COM[/TD]
[TD="class: xl67, width: 64"]BVILLE[/TD]
[TD="class: xl67, width: 64"]CUR[/TD]
[TD="class: xl67, width: 64"]CAP[/TD]
[TD="class: xl67, width: 64"]WV2P[/TD]
[TD="class: xl67, width: 64"]PAM[/TD]
[/TR]
[TR]
[TD="class: xl70"]40 [/TD]
[TD="class: xl65"]16[/TD]
[TD="class: xl65"]16[/TD]
[TD="class: xl65"]8[/TD]
[TD="class: xl65"]32[/TD]
[TD="class: xl65"]64[/TD]
[/TR]
[TR]
[TD="class: xl68"]MPB[/TD]
[TD="class: xl67"]ACB[/TD]
[TD="class: xl67"]TZ[/TD]
[TD="class: xl67"]I-84[/TD]
[TD="class: xl67"]Traf[/TD]
[TD="class: xl67"]BAL[/TD]
[/TR]
[TR]
[TD="class: xl65"]40[/TD]
[TD="class: xl65"]8[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]24[/TD]
[TD="class: xl65"]16[/TD]
[TD="class: xl65"]16[/TD]
[/TR]
[TR]
[TD="class: xl67"]MFE DM[/TD]
[TD="class: xl67"]MKT[/TD]
[TD="class: xl68"]219[/TD]
[TD="class: xl67"]I79[/TD]
[TD="class: xl68"]Ohl[/TD]
[TD="class: xl67"]PAM[/TD]
[/TR]
[TR]
[TD="class: xl65"]32[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]24[/TD]
[TD="class: xl65"]64[/TD]
[TD="class: xl65"]8[/TD]
[TD="class: xl65"]6[/TD]
[/TR]
[TR]
[TD="class: xl67"]PAM[/TD]
[TD="class: xl69"]COM[/TD]
[TD="class: xl67"]BVILLE[/TD]
[TD="class: xl67"]GT[/TD]
[TD="class: xl67"]ACB[/TD]
[TD="class: xl69"]COM[/TD]
[/TR]
[TR]
[TD="class: xl65"]40[/TD]
[TD="class: xl70"]40 [/TD]
[TD="class: xl65"]16[/TD]
[TD="class: xl65"]32[/TD]
[TD="class: xl65"]4[/TD]
[TD="class: xl70"]6 [/TD]
[/TR]
</tbody>[/TABLE]

For example, if I needed to sum the Values for "COM" it would return a total of 86. Thanks - this would be a huge time savor!

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G	H
1	COM	BVILLE	CUR	CAP	WV2P	PAM		COM
2	40	16	16	8	32	64		86
3	MPB	ACB	TZ	I-84	Traf	BAL
4	40	8	0	24	16	16
5	MFE DM	MKT	219	I79	Ohl	PAM
6	32	0	24	64	8	6
7	PAM	COM	BVILLE	GT	ACB	COM
8	40	40	16	32	4	6
Master

Cell Formulas
Range	Formula
H2	=SUMPRODUCT(--($A$1:$F$7=H1),($A$2:$F$8))