# Need formula to find item in one column then sum amounts in the next column that match

#### RitaB

##### New Member
I'm pulling my hair out on this one. I have a spreadsheet and in one column there is drop-down where you can select cash, check, credit. The next column has the amount paid. I need a formula that will look for all cash entries in the first column, then move to the next column and sum the amount of all the cash entries. Then a formula that would do the same, but look for checks, and credit amounts and then sum those. I tried using the vlookup and hlookup, but I can't figure out how to make it look for multiple amounts. Can anyone help me with this? I certainly appreciate any help! Thanks.

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### VoG

##### Legend
Hello and welcome to MrExcel.

SUMIF should work

=SUMIF(C1:C100,"cash",D1:D100)

change the ranges to suit.

#### xld

##### Banned
Looks like

=SUMIF(A:A,dropdwon_value,B:B)

of course, adjust the columns to suit.

#### gardnertoo

##### Well-known Member
SUMIF is the function you want:
Book2
ABCDE
1Charge75.42Cash577.81
2Cash4.42Check296.62
5Cash17.99
6Check60.58
7Charge25.52
8Charge41.15
9Cash62.43
11Check69.46
12Check91.21
13Charge87.48
14Check31.49
15Cash28.4
16Cash47.34
17Cash8.27
18Cash24.26
19Cash82.03
21Check43.88
23Cash86.01
24Cash45.02
25Cash92.63
Sheet1

#### RitaB

##### New Member
Looks like

=SUMIF(A:A,dropdwon_value,B:B)

of course, adjust the columns to suit.
Thank you so much for the quick reply - the sumif was the answer. I have been trying to figure this out for a couple of days and I could have sent to this group. So happy to have found you guys! Thanks again.

#### RitaB

##### New Member
I don't know if I'm supposed to reply to everyone, but thanks so much for you answer. This worked and I'm so relieved to have an answer!

#### RitaB

##### New Member
I'm thanking everyone that send a response. The sumif worked, and I am so thankful for this group. What a relief!

#### xld

##### Banned
You are not SUPPOSED to thank anyone, that you do shows you have integrity. But don't bother thanking everyone, a simple thanks suffices.

Replies
2
Views
331
Replies
14
Views
696
Replies
1
Views
575
Replies
1
Views
359
Replies
3
Views
275

1,191,686
Messages
5,988,004
Members
440,125
Latest member
vincentchu2369

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