Have a 156 account numbers, I need to calculate the totals based on the last 4 digits... but wait there's more

[moonlight6]

So, I have 156 account numbers with 17 digits. The only numbers that matter on the account number are the last four digits. I need to take the balance of each number and sum them together based on the last four digits or a range of the last four digits. For instance, say I have
12 0000 0000 000 1110
10 0000 0000 000 1116
21 0000 0000 000 1790
61 0000 0000 000 1171
33 0000 0000 000 3803

I need to add the balances of any account number ending between 1110-1119, 1700-1799. I need to add the balances of any account number ending 1171. How do I get it to add them based on this? I'm trying to find the easiest way possible, if possible. Thanks for your help!!!!

 

[moonlight6]

 

[alansidman]

A sample of your data with 8-15 Records uploaded using XL2BB so that we don't have to try and create what you already have would be really helpful. Then using XL2Bb provide us with a mocked up solution of what you want the result to look like.

 

[moonlight6]

I'm not sure I will be able to us the XL2BB without my IT people stepping in. Here's an example of how I was getting it to work. This required me to sort and pick for instance numbers ending 1110-1119 and then adding them. But not table I do will have the same ending numbers. This one only had 1111 and 1114. The next one may have 1113 and 1118. So, I'm trying to find a way either function or code that will add them up based on the last 4 digits of the account number. And either a set number or a range.
=SUM('Table 1'!M2,'Table 1'!M3,'Table 1'!M4,'Table 1'!M5,'Table 1'!M94,'Table 1'!M112,'Table 1'!M122)

 

[moonlight6]

I will add that the calculated range/set numbers will be the same across the board. It's just the account numbers that may change dependent on the table I'm using.