Looking up values using a range name and then adding the values to find the sum.

I use to know how to do this but now I cannot figure it out. I am trying to find the sum of the accounts listed under range name Sales in Tab3 by pulling the information from TAB2. The sum of accounts 4100, 4200, 4500 should be $1,100.00. This is just a sample of a large amount of data I have. I am not sure if I should be using a vlookup or what kind of formula to get to the answer. Any help would be appreciated. Thanks.

TAB1 - Statement

Sales $?
Refunds


TAB 2 - Account Numbers and Amounts
Account Amount
4100 $100.00
4150 $200.00
4200 $300.00
4250 $400.00
4300 $500.00
4400 $600.00
4500 $700.00


Tab 3 - Range Names

Sales
4100
4200
4500


Refunds
4150

try sumproduct

=SUMPRODUCT(SUMIF('Trial Balance'!A:A,Sales,'Trial Balance'!B:B))