Lookup One Column - Sum Another

[pw034]

I have a spreadsheet that contains text in one column and then dollar
amounts in the other. I am looking for a way to search the text and
sum all the dollar amounts that equal the text. Example:

COLUMN A[/B] COLUMN B
$1,500.00 CD
$1,000.00 CD
$5,000.00 CD
$7,724.40 CL
$2,000.00 CL
$2,183.08 CL

I am looking for a formula that will search for CD (located in column
B) and sum all the amounts (located in column A), search for CL
(located in column B) and sum all those amounts (located in Column A)
and so on.

So in this example, CD=$7,500.00 and CL=$11,907.48

Thank you in advance for the help!

Paul

 

[Peo Sjoblom]

=SUMIF(B:B,"CD",A:A)

do the same for CL or replace both by a cell reference where you can type in
the criteria
e.g.

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



--
Regards,

Peo Sjoblom

(No private emails please)

 

[pw034]

That did it! Than you so much