How do I add a column subject to a qualifying entry in an adjacent column?

[marvelousm]

I want to add the entries in one column to make subtotals qualified by a letter in another column.

[Tony Valko]

something like this...


Data Range

	A	B	C	D	E
1	Letter	Amount	-----	Letter	Total
2	A	18		A	222
3	S	20		S	47
4	D	86		D	280
5	A	72
6	D	96
7	A	80
8	A	52
9	S	27
10	D	98

This formula entered in 2 and copied down:

=SUMIF(A:A,D2,B:B)