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

IF/OR/AND function in a formula 5
Data displayed that is not equal to FALSE in a row 3
For Eachcell in Range tranpose comma seperated values to a list in D 4
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
SHORTEN A FORMULA BY AVOIDING SETTING UP AN ADDITIONAL COLUMN 4
Rolling up a snapshot of data by month 1
How to find duplicate cells in Column a & retrieve column B 2
Search a table using three criterion 0

Top