One way:

=SUMPRODUCT(SUMIF(A1:A20,D1:D3,B1:B20))

--
Biff
Microsoft Excel MVP


"FARAZ QURESHI" wrote in message
...
I have a list like follows in A1:B20:

E 584
C 421
C 123
A 672
C 284
D 626
D 863
D 930
B 964
D 263
D 750
A 287
A 680
E 660
C 946
C 970
C 989
E 560
D 186
A 78

In cells D1:D3 I have A, C & E. I want to insert a formula in D4 which
would
sum up the amounts from B1:B20 which have corresponding cells in A1:A20
with
the values present in D1, D2 & D3. That is amounts against A, C & E.

Any Idea?

Thanx in advance friends