How do you create a Sum formula based on a columns particular content?

[cbjornn]

I tried to search for this but was unable to locate anything.

I am trying to find how to create a Sum formula that only adds to the amount if another column on the same row is for "Fraud".

For example:

Column 1 = Charge back amount
Column 2 = Reason
Column 3 = Sum of charge back amount for reason "Fraud"

I only want the amount to be added if the reason if for Fraud.

Can this be done?

Thanks!!!

 

[Marcelo Branco]

Try SUMIF

M.

 

[rob.barnes01]

Is column C a running total? If so, try: =SUMIF($B$2:B2,"Fraud",$A$2:A2)