I have a table with several columns including date and amount ($). I'm trying to create a function that will take a month and the table as inputs, and return the SUM of the amounts listed in that month.

For example:

TABLE1

Date Amount
1/12/11 $10
1/30/11 $8
3/6/11 $15
8/20/11 $13
1/2/11 $4
6/5/11 $8

So I want to make a function =SUMMONTH(month,table or array)

In this case =SUMMONTH(January,TABLE1) = $22