# IF or something else?

#### 513lette

##### New Member
Hello! Im glad I found this forum, because Im pretty new to Excel, but I need to start learning it. Please let me know if I need to change how I attached a photo of the table.

I am trying to figure out how to take a column of numbers and multiply them by 2.75%, but I only need the formula to be applied to certain cells in that column. I tried the SUMIF formula a few times, but kept getting errors, so Im not sure if its me, or if its just not the right one to use.

Heres the table in question. I need to take the total column, and figure out how much in fees (2.75%) will come out of that, but only if the total is a result of a transaction that is listed under the card column, as fees aren't deducted from cash transactions. (its actually bigger than this, row wise, but I didn't want to talk up too much space)

 card cash Tax Tip total fee 100 7.50 10.00 117.50 100 7.50 107.50 100 7.50 6.50 114.00 75 5.63 80.63

<tbody>
</tbody>

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### FormR

##### MrExcel MVP
Hi, welcome to the forum!

Something like this maybe:

#### 513lette

##### New Member
Oh my, thats perfect, and so much easier than I was trying to make it. Thank you very much.

#### RoryA

##### MrExcel MVP, Moderator
Welcome to the forum.

Replies
5
Views
103
Replies
0
Views
104
Replies
1
Views
55
Replies
4
Views
74
Replies
3
Views
109

1,136,283
Messages
5,674,831
Members
419,529
Latest member
TommasoP11

### 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