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

#### cbjornn

##### New Member
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!!!

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Try SUMIF

M.

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

Replies
2
Views
174
Replies
1
Views
132
Replies
2
Views
244
Replies
5
Views
332
Replies
6
Views
159

1,203,108
Messages
6,053,561
Members
444,673
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back