View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default SUMMING UP ONLY ONES IN A LIST

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