sumbasedondate

Date Amount

1/1/2008 1 7

1/5/2008 1

1/9/2008 1 Enter Formula using Ctrl + Shift + Enter (Array Formula)

1/13/2008 1 =SUM(IF(MONTH(B2:B29)=2,C2:C29,0))

1/17/2008 1

1/21/2008 1

1/25/2008 1

1/29/2008 1

2/2/2008 1

2/6/2008 1

2/10/2008 1

2/14/2008 1

2/18/2008 1

2/22/2008 1

2/26/2008 1

3/1/2008 1

3/5/2008 1

3/9/2008 1

3/13/2008 1

3/17/2008 1

3/21/2008 1

3/25/2008 1

3/29/2008 1

4/2/2008 1

4/6/2008 1

4/10/2008 1

4/14/2008 1

4/18/2008 1

+ Enter (Array Formula)