SUMIF with multiple ranges

[fleetwood417]

Good afternoon. I made a mini excel spreadsheet for monitoring gains/losses on a mutual fund. In column B, I have the transaction type, (Purchase, Withdrawl, Dividend). Column C has the dollar amount for each of these transaction type. Is there a way to Sum the dollar amount in Column C if the transaction type is either "Purchase" or "Withrdrawl"?

[Tony Valko]

One way...

=SUM(SUMIF(B:B,{"Purchase","Withdrawl"},C:C))

[fleetwood417]

That worked perfectly. Thank you!

[Tony Valko]

You're welcome. Thanks for the feedback!

[FDibbins]

Tony, you never cease to blow me away!! I would have used...
=SUMIF(B:B,"Purchase",C:C)+SUMIF(B:B,"Withdrawl",C:C)

[Tony Valko]

Tony, you never cease to blow me away!!

----------

[AlKey]

Or this

=SUMPRODUCT((B:B={"Purchase","Withdrawl"})*(C:C))

[Tony Valko]

Or this

=SUMPRODUCT((B:B={"Purchase","Withdrawl"})*(C:C))

That's very inefficient.

You should avoid using entire columns as range references in array formulas and the SUMPRODUCT function.

A1 = Purchase
A2 = Withdrawl

=SUMPRODUCT(SUMIF(B:B,A1:A2,C:C))

In this application the SUMIF function can efficiently handle the entire column references.