Excel 2003 – sum with criteria being a range

I have a list of customers on one workbook and want to pull the balances from a customer list on a separate workbook into a single cell. I need to find a sum formula where the criteria can be a range – can anybody help?