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.

COM	BVILLE	CUR	CAP	WV2P	PAM
40	16	16	8	32	64
MPB	ACB	TZ	I-84	Traf	BAL
40	8	0	24	16	16
MFE DM	MKT	219	I79	Ohl	PAM
32	0	24	64	8	6
PAM	COM	BVILLE	GT	ACB	COM
40	40	16	32	4	6

<tbody>
</tbody>

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))