Add up values in cells based on a lookup value

[JCUK89]

Hi,

I have a data set of buildings and their values. I have zip codes in one column (call it column A), and property values in the next column, (call it column B).

I then have a separate list of certain zip codes - named range 'zips' in column C. I want a formula to find all of the zip codes shown in 'zips' in column A, and add up all of the values in column B.

Hope that makes sense?

Thanks for any help!

 

[Peter_SSs]

Like this?

Excel Workbook
	A	B	C	D
1	ZIP	Value	zips	Total
2	65984	100,000	12345	220,000
3	48562	150,000	77777
4	77777	120,000	65984
5	58956	99000
6
ZIPs

#VALUE!

</td></tr></table></td></tr></table>