SUMMING UP ONLY ONES IN A LIST

F

FARAZ QURESHI

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

up and down array 5
IF/OR/AND function in a formula 5
Data displayed that is not equal to FALSE in a row 3
LOOPING STRUCTURE DESIRED 4 TWO RANGES 2
ROUND UP HOURS to the next quarter hour 2
Copy data output only to new worksheet. 5
vlookup question - bring in all values? 6
How to find duplicate cells in Column a & retrieve column B 2

Top