Sum Lookup Match

Please help ! Ok, I'm trying to populate a row of cells based off of a lookup (match) that is on a different sheet. The value I'm trying to match on the other sheet is in one column, and where there is a match, I want to pull in a value from that row where the match is, except in a different column. I'll try and explain. Sheet 1: For D1's value, lookup the state name in C1 and match it to column A in Sheet 2. Where there is a match in column A on sheet 2, pull in the value from that row under column B. There can be multiple matches from Sheert 2, so it will need to sum all of the instances where there is a match. I've attached a spreadsheet to better illustrate.

Example WB.xlsx