[Help Needed] Sum IF matching partial text via single cell using numeric values for match

[Lyryx]

In excel work book one, I have account codes that look like this.
[TABLE="width: 159"]
<tbody>[TR]
[TD]00-1-110-31011[/TD]
[/TR]
[TR]
[TD]00-1-110-31031[/TD]
[/TR]
[TR]
[TD]00-1-110-31042[/TD]
[/TR]
</tbody>[/TABLE]

This account code occupies one cell and is followed by a $ value in the next adjacent cell.

In excel work book two, I have account codes that look like this.

[TABLE="width: 169"]
<tbody>[TR]
[TD]110-31011 Total[/TD]
[/TR]
[TR]
[TD]110-31031 Total[/TD]
[/TR]
[TR]
[TD]110-31042 Total[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
This account code occupies one cell as well. and is followed by a $ value in the next adjacent cell too.

I need to match the information from excel work book 2 and transfer it into work book 1. I would normally use a SumIF function for this but the cell's information isn't an exact match between cells. Excel Workbook 2 is also set up as a subtotal which may affect the formula required as well.



Is there a variation of the SumIF formula I can use to look up the corresponding values in the 2nd workbook to populate the first workbook?

Thank you in advance. ​

 

[njimack]

You can convert from the format in book 1 to the format in book 2 using the below formula, which could be incorporated into your SUMIF function:
=RIGHT(A1,LEN(A1)-5)&" Total"

 

[123rickfear]

if you put a helper column on sheet 1 you can do it. in your new column out the formula =right(A:A,9)

then in your sheet 2 you can uses the formula =SUMIF(Sheet1!C:C,LEFT(Sheet2!A1,9),Sheet1!B:B) C:C being the new column in sheet 1

 

[Lyryx]

I never knew about the Right or Left functions. Thank you very much! You've both saved me quite a bit of time going forward. Can't wait to put these to work