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

[RitaB]

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.

 

[VoG]

Hello and welcome to MrExcel.

SUMIF should work

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

change the ranges to suit.

 

[xld]

Looks like

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

of course, adjust the columns to suit.

 

[gardnertoo]

SUMIF is the function you want:

Book2
	A	B	C	D	E
1	Charge	75.42		Cash	577.81
2	Cash	4.42		Check	296.62
3	Trade for goats	2		Charge	229.57
4	Cash	79.01		Trade for goats	21
5	Cash	17.99
6	Check	60.58
7	Charge	25.52
8	Charge	41.15
9	Cash	62.43
10	Trade for goats	4
11	Check	69.46
12	Check	91.21
13	Charge	87.48
14	Check	31.49
15	Cash	28.4
16	Cash	47.34
17	Cash	8.27
18	Cash	24.26
19	Cash	82.03
20	Trade for goats	12
21	Check	43.88
22	Trade for goats	3
23	Cash	86.01
24	Cash	45.02
25	Cash	92.63
Sheet1

 

[RitaB]

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]

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]

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

 

[xld]

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