Formula Help

[Alex O]

Is there a formula that I can use to get the sum in of all entries in H7:H16 that end with BD? I'm completely brain dead on this!

	H	I
7	MA/BD	700,477
8	MA/PD	10,717
9	SOUTHERN/BD	5,486
10	SOUTHERN/PD	0
11	NEW MKT/BD	13,053
12	NEW MKT/PD	0
13	NJ/BD	1,377
14	NJ/PD	0
15	NY/BD	14,425
16	NY/PD	0
17	BD Total
18	PD Total

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 140px;"><col style="width: 52px;"></colgroup><tbody>
</tbody>

 

[Michael M]

Try

=SUMPRODUCT(--(RIGHT(H7:H16,2)="BD")*(I7:I16))

 

[Alex O]

Perfect....thanks!