Vlookup with wild-card and multiple lookup values

Hello,

I'm trying to find a formula that will solve the attached. I would like to use a 2-digit number as a look-up value to find matching number+letter codes, and then add the corresponding column amounts together. I'm using a wildcard because the look-up value will only contain the 2-digit number. So far I cannot get this to work using VLookup since it only looks at the first value, but I'm not sure how to move past this.

Does anyone have any ideas on how this could work?

Thanks,
Jason

Thanks for your replies! The SUMIF function works, but the range will not always be the same. The MARKET SEGMENT I used was just a small example of a larger file that is copied into the worksheet each day. I've attached a revised file with the actual data for one day in the REAL MARKET SEGMENT tab.

The data I'm looking for is in columns L & M, based on what's in column A. The data for a particular day could start a few rows above or below row 84. Can the range in the SUMIF function be made variable to account for different beginning row number?

Thank you,
Jason

Thank you for all the replies to my question!

I've solved this using the SUMIFS formulas provided, but can I ask a follow-up question? There are 2 rows in the range that have the words "TOTALS" and "SUBTOTAL" in them, and this is making the calculations incorrect. I've tried to insert "<>*TOTALS*", "<>*SUBTOTAL*" into the formula, but I'm getting error messages no matter where I insert. For example, this gives me an error message:

Please Login or Register  to view this content.

Is there a way to amend the SUMIFS formula to have the 2 rows with these 2 words not included?

Many Thanks,
Jason

I figured out how to exclude the words "SUBTOTAL" and "TOTALS" using the code below:

Please Login or Register  to view this content.

Thanks for the help with this one.

Jason