I have excel data in following format.

```
Date        Amount

03-Jan-13   430.00 
25-Jan-13   96.00 
10-Jan-13   440.00 
28-Feb-13   72.10 
28-Feb-13   72.30

```

I need to sum the amount field only if the month lies in **Jan** Month.

What i have tried is ,

```
=SUMIF(A2:A6,"MONTH(A2:A6)=1",B2:B6)

```

But it returns, 

```
0

```

What i need is,

```
Following values to be summed, 430.00 + 96.00 + 440.00 = 966.00

```