Sumif with criteria variable

[ReportingRuth]

I have a list of names and values. Names repeat. Want to sum values for repeated names. This code doesn't work. I think criteria needs to be "apples" and not a variable. Any ideas?

Thanks,
~RUTH~

=SUMIF(E3:E112,AB5,N3:N112)

E are names repeated.
N is values to be summed for repeated names.
AB is a specific name.

 

[VoG]

That should work. Maybe if you are looking for contains the value

=SUMIF(E3:E112,"*"&AB5&"*",N3:N112)

 

[ReportingRuth]

"*"&AB5&"*" gives you *Name* so it gives an unexpected value. I think it needs just Name but I want that to be a variable.

That should work. Maybe if you are looking for contains the value

=SUMIF(E3:E112,"*"&AB5&"*",N3:N112)

 

[VoG]

I don't get #Name with that formula. What are you trying to do?

 

[ReportingRuth]

I don't get #Name either. I was saying name as a variable. Your formula gives *Answer* instead of just "Answer".

I don't get #Name with that formula. What are you trying to do?

 

[VoG]

I do not understand. Please post an example and your expected result.

 

[scottylad2]

not sure why you're not getting an answer, is your syntax like this and are the values your summing actual numeric values?

Excel Workbook
	L	M	N	O	P
6	Object	Amount	Criteria	Total	W/Vogs Sample
7	apples	270	Apples	1019	2210
8	oranges	425	Oranges	1331	1331
9	lemons	493	Lemons	1396	1396
10	lemons	215
11	apples	324
12	apples	425
13	oranges	263
14	oranges	279
15	oranges	364
16	lemons	333
17	lemons	355
18	brown apples	239
19	brown apples	497
20	brown apples	455
Sheet1

Excel Workbook
	P
7	2210
Sheet1

 

[ReportingRuth]

Thank you for your example. This is good. I didn't understand my data correctly. You were right N7 works just fine alone.

Thanks again,
~RUTH~

not sure why you're not getting an answer, is your syntax like this and are the values your summing actual numeric values?

Excel Workbook
	L	M	N	O	P
6	Object	Amount	Criteria	Total	W/Vogs Sample
7	apples	270	Apples	1019	2210
8	oranges	425	Oranges	1331	1331
9	lemons	493	Lemons	1396	1396
10	lemons	215
11	apples	324
12	apples	425
13	oranges	263
14	oranges	279
15	oranges	364
16	lemons	333
17	lemons	355
18	brown apples	239
19	brown apples	497
20	brown apples	455
Sheet1

Excel Workbook
	P
7	2210
Sheet1