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 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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[pw034]

That did it! Than you so much