SumIf using vlookup with multiple matches

[elfrider]

Hi,

I'm looking to sum the values in one column (column C) based on multiple matches from a vlookup in the table B1:C100. My vlookup is definitely working, but my sumif statement is returning incorrect values:

=SUMIF(B1:C100, VLOOKUP("LookupValue",B1:C100,2,FALSE))

Any ideas on this one please?

Thanks.

 

[CA_Punit]

Considering your example and what i suppose

SUMIF(C1:C100, VLOOKUP("LookupValue",B1:C100,2,FALSE), SUMRANGE)

Please select Sumrange.

Your formula has various issues
1. criteria range cannot be two range (B1:C100)
2. You have not entered the last Argument i.e Sum Range
3.

I'm looking to sum the values in one column (column C)

I am not able to understand the Line because in vlookup you are taking C1:C100 as your lookup value which is the criteria.

Please reframe the question to make me understand better

 

[elfrider]

Hi,

Thanks for the reply,

I've changed the criteria range to be C1:C100. The values I'm looking to sum are also held within C1:C100 (I probably should have specified that instead just saying Column C).

What do I put in the SUM_RANGE argument? Is that not the same (C1:C100)?

My formula now looks like this but the result is the exact same as before:

SUMIF(C1:C100, VLOOKUP("LookupValue",B1:C100,2,FALSE), C1:C100)

Thanks.

 

[Fluff]

Can you post some sample data, including expected results, using the XL2BB add-in?
Also please update your account details to show which version of Excel you are using, as this affects which functions you have.

 

[elfrider]

Hi,

See attached image with sample data (can't install XL2BB as using my corporate laptop). I need my formula to return the value 23 by looking up 'LookupValue' in column B and adding the 4 matches from the Column C.

Thanks.

 

[elfrider]

P.S My actual range goes down to row 100, I just created the screenshot for illustration.

 

[Fluff]

How about
=sumifs(C1:C100,B1:B100,"LookupValue")

Also please update your account details to show your Excel version.

 

[elfrider]

Thanks for your help. Now working ☺

 

[Fluff]

You're welcome & thanks for the feedback.