Lookup One Column - Sum Another
 

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] [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


--
pw034
------------------------------------------------------------------------
pw034's Profile: http://www.excelforum.com/member.php...fo&userid=7091
View this thread: http://www.excelforum.com/showthread...hreadid=496570

Lookup One Column - Sum Another
 

=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" wrote in
message ...

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] [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


--
pw034
------------------------------------------------------------------------
pw034's Profile:
http://www.excelforum.com/member.php...fo&userid=7091
View this thread: http://www.excelforum.com/showthread...hreadid=496570

Lookup One Column - Sum Another
 

That did it! Than you so much :)


--
pw034
------------------------------------------------------------------------
pw034's Profile: http://www.excelforum.com/member.php...fo&userid=7091
View this thread: http://www.excelforum.com/showthread...hreadid=496570