I need to sum a values using multiple criteria and a date range.

Example - I need to sum the total amount of all investors that have an "N"
in the n/e column, are in a specified region, in a specified fund, and are
between the dates of 2/1/2010 through 3/1/10. Can't seem to get this to
work? Any help is greatly appreciated.

n/e Inv Date Investors Amount Fund Region
E 2/1/2010 Client 1 $250,000 1 Asia
E 2/1/2010 Client 2 $20,000 2 North America
N 2/1/2010 Client 3 $14,000 4 North America
N 2/1/2010 Client 4 $11,000 10 Asia
E 2/1/2010 Client 5 $7,000,000 9 Europe
E 2/1/2010 Client 6 $6,500 6 Europe
E 2/1/2010 Client 7 $5,000,000 5 Asia
N 2/1/2010 Client 8 $4,000 2 Canda
E 2/1/2010 Client 9 $2,500,000 2 Canda